SQL是否存在表或列

是否存在表

if not exists (SELECT   name   FROM   sysobjects   where   name= 'T_SCS_Student_OtherChargeItemExtend')

begin

end

是否存在列名

if not exists( select * from syscolumns where id=object_id('T_SCS_OtherChargeItem') and name='ChargeStanderd')

begin

end";