摘要:
--drop table index_tbcreate table index_tb(id int constraint ck_id default 0,name varchar(20),xb varchar(2))--查看表exec sp_helpindex orders--索引exec sp_helpconstraint index_tb --约束exec sp_fkeys 'dbo.Person'--外键--键不唯一,非聚集索引create index id_index on index_tb(id)--删除索引drop index index_tb.id_index-- 阅读全文