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

2012-08-09

如何判断表中是否存在某列如题[解决办法]SQL codeif exists(select * from syscolumns where idobject_id

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

[解决办法]

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 '不'

热点排行

Bad Request.

SQL Server

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