add column for a table if this column not exists using T-SQL in SQLServer
Easoney·2009-04-28·via 博客园 - Easoney
IFNOTEXISTS (SELECT*FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='LandlordInfo'AND COLUMN_NAME ='IsSigned') BEGIN ALTERTABLE LandlordInfo ADD IsSigned bitnull END