mssql 刪索引,加索引

if exists(select name from sys.indexes where name='IX_xxx')
begin
   drop INDEX book.IX_xxx
end
if not exists(select name from sys.indexes where name='IX_xxx')
begin
  CREATE INDEX IX_xxx
  ON book (vip_id)
end