Posted by Gert-Jan Strik on 05/28/05 00:27

Just to add to the previous responses: the DROP_EXISTING feature is
indeed very useful. But there is no reason to shy away from using UNIQUE
constraints (or Primary Key constraints), because CREATE INDEX ... WITH
DROP_EXISTING will also work on indexes that enforce uniqueness of these
constraints.

Gert-Jan

• Next in forum: Re: SQL Automatic Growth
• Prev in forum: Re: Query Help, thanks!
• Thread view: Re: What's the difference? Unque Constraint and unique index, etc.?

[Reply to this message]