create unique clustered index xs_ind on xs(sno)-2.sql

在学习SQL Server过程中整理的T-SQL语句

use test
if exists(select name from sysindexes where name='IX_XS')
     drop index XS.IX_XS
go
create unique clustered index xs_ind on XS(sno)
       with ignore_dup_key
go