sqlserver删除 数据库索引 前先判断

删除索引前先判断
if exists(select * from sysindexes where id=object_id('t_cash_value_rate_his'(表名)) and name='idx__unique_t_cash_value_rate_his'(索引名))    
drop index idx__unique_t_cash_value_rate_his on t_cash_value_rate_his;
删除表列之前先判断
if exists(select * from syscolumns where id=object_id('t_cash_value_rate_his'(表名)) and name='waiver_period'(列名))  
alter table t_cash_value_rate_his drop column waiver_period;