摘要： if not exists( select 1 from dbo.syscolumns s where name ='yourColumn' and id = object_id(N'YourTable')) begin alter table YourTable add yourColumn ColumnType end 阅读全文