怎么判断表中是否存在某列_Sql Server

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

------解决方案--------------------

SQL code

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