Re: Defragging a table with Foreign Keys

From: Brian Peasland <peasland_at_usgs.gov>
Date: Tue, 20 Feb 2001 16:07:15 GMT
Message-ID: <3A929633.3B4B2B6B@usgs.gov>

Drop the FK constraints to the table, defragment the table, and then add the FK constraints. If there is 1 FK constraint, or 100 FK constraints, the procedures is the same!

HTH,
Brian

Douglas Scott wrote:
>
> Does anyone know a good way to defragment a table that has alot of
> foreign keys related to it?
>
> Douglas Scott

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Tue Feb 20 2001 - 10:07:15 CST