sql 索引

sp_helpindex @objname='ma_lot' --判断某表的索引是不是存在

 

 

IF EXISTS(SELECT * FROM SYSINDEXES WHERE name='test')
PRINT 'cunzai'

DROP INDEX ma_lot.test
GO
ELSE
PRINT 'bucunzai'

--创建索引

CREATE CLUSTERED INDEX test
ON dbo.mm(MName)