By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,929 Members | 634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,929 IT Pros & Developers. It's quick & easy.

clustered index

P: 5
can we create clustered index on non primary key
Dec 26 '06 #1
Share this Question
Share on Google+
1 Reply


almaz
Expert 100+
P: 168
Try to use SQL Books Online first:
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON <object> ( column [ ASC | DESC ] [ ,...n ] )
....
It means that index can be either clustered on non-clustered. Please note that there can be only one clustered index per table.
Dec 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.