Monday, July 27, 2015

What's the distinction between CREATE NONCLUSTERED INDEX and CREATE INDEX in T-SQL?

This suggests there is not one. Unless a clustered index is specified, the default for "CREATE INDEX" is to create a nonclustered index. In either of this cases if the word CREATE is immediately followed by UNIQUE then no two keys may be the same.

No comments:

Post a Comment