怎样判断一个字段是否存在？

[djnj_0]

怎样用SQL命令来判断一个字段在一个表中是否存在

[CrazyFor]

if (SELECT count(*)
FROM syscolumns
WHERE (id =
(SELECT id
FROM sysobjects
WHERE (name = YourTableName'))) and name='filedName')>0
begin
print '存在！'
end

[j9988]

id=object_id('tablename')
替代:
(id =
(SELECT id
FROM sysobjects
WHERE (name = YourTableName')))

[newyu1127]

可以这样：
if (SELECT count(*)FROM syscolumns WHERE (id =(SELECT id FROM sysobjects WHERE (name ='tablename'))) and name='fieldname')>0
print '字段存在！'
else print '字段不存在！'

[djnj_0]

谢谢，其实用一个系统存储过程 sp_columns 也可以解决这个问题

[蓝天]

if exists (select name from syscolumns where id = object_id('tablename') and name like 'columnname') print 'ok' else print 'not ok'

[蓝天]

if exists (select name from syscolumns where id = object_id('tablename') and name = 'columnname') print 'ok' else print 'not ok'

[chump]

楼上的讲的好！