sqlbuddy123 (7/15/2010)
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
Well said , i missed this point
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)