判断字段是否存在

use Northwind

if  exists(select 1 from  syscolumns where  id  =  object_id('customers') and name  =  'filed')

begin

alter table Customers drop column filed

print ' exists '
end

alter table Customers add  filed float null

 

 

说明：在SQL里 syscolumns ，object_id ，name 是关键字