[dba-SQLServer] Are indexes unique

jwcolby jwcolby at colbyconsulting.com
Mon Aug 29 11:32:39 CDT 2011

If I have a clustered index on my PK (autoincrement int) and that is used in all indexes without 
specififying that it be used (my understanding) does that mean that every index is by definition 
unique?  Do I need to check the unique box when creating the index?

Or does "unique" only count on the actual fields specified in the index?
John W. Colby

More information about the dba-SQLServer mailing list