create unique clustered index kc_id_ind on kc(cno).sql

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

use test
if exists(select name from sysindexes where name='kc_id_ind')
     drop index KC.kc_id_ind
go
create unique clustered index kc_id_ind on KC(cno)
go