Home Forums SQL Server 2005 Administering Primary key without cluster index RE: Primary key without cluster index
SQLBuddy123
One Orange Chip
Points: 28294
More actions
July 15, 2010 at 9:08 am
#1193565
PK by default creates a unique clustered index if one doesn't already exists.
If a clusterd index already exists, you can specify NON CLUSTERED clause to create a noon clustered index.
Thank You,
Best Regards.
SQLBuddy