create index xs_kc_ind on xs_kc(sno,cno).sql

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

use test
if exists(select name from sysindexes where name='xs_kc_ind')
    drop index XS_KC.xs_kc_ind
go
create index xs_kc_ind on XS_KC(sno,cno)
go