导读:判断数据表中是否存在列--并添加 。IF NOT (SELECT COUNT(*) FROM syscolumns a JOIN sysobjects b ON a.id = b.id AND b....
判断数据表中是否存在列--并添加 。
IF NOT (SELECT COUNT(*) FROM syscolumns a
JOIN sysobjects b ON a.id = b.id AND b.xtype='U' AND b.[name]='dbo.Meal_WXReservationFoods'
WHERE a.[name]='MySQLreservedId')=0 --判断数据库中表[Meal_WXReservationFoods] 中是否存在列明为 [MySQLreservedId]项
BEGIN --不存在则执行
ALTER TABLE dbo.[Meal_WXReservationFoods] ADD [MySQLreservedId] INT NULL
END