如何判断表中是否存在某列
如题

[解决办法]

SQL code

if exists(select * from syscolumns where id=object_id('tableName') and name='columnName')print '存在'elseprint '不存在'
[解决办法]
SQL code
IF EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB') AND NAME='FDAF')PRINT '存在'
[解决办法]
 
SQL code
if exists(select * from sys.syscolumns where id=object_id('表名') and name='字段名') print '在'elseprint '不'