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

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 7 行

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