Saturday, February 25, 2012

Create INDEX WITH DROP_EXISTING

Hello,
Can I create an index ( which is not clustered) with DROP_EXISTING ON ?
Shall I still use on [PRIMARY]?
Create INDEX [name] ON [table name] ([column])
WITH DROP_EXISTING ON [PRIMARY]
Thank you,
Y
:rolleyes:clustered or not, you can use this.

Primary refers to the filegroup you would like to physically create the index on and it is an optional part of the create index statement.|||Thank you so much

No comments:

Post a Comment