如何判断数据表的某个字段是否存在

[kvkensin]

例如我想知道成绩这张表是否有姓名这个字段，请问sql语句怎么写？多谢

[SQL77]

SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB')

[nianran520]

select count(1) from syscolumns where name = '姓名'
and id = object_id('成绩')

[翼帆]

if exists(select 1 from SYSCOLUMNS where id = object_id('TB') and name = '姓名')
print '有姓名这个字段'

[幸运的意外]

SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB') and NAME = '需要检测的字段名'

[guguda2008]

SELECT '存在' FROM SYS.COLUMNS WHERE [OBJECT_ID]=OBJECT_ID('表名') AND [NAME]='列名'

[guguda2008]

SYS.COLUMNS这个视图里有你要的东西

[Mr_Nice]

SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB') 

[fly0012008]

[Quote=引用楼主 kvkensin 的回复:]
例如我想知道成绩这张表是否有姓名这个字段，请问sql语句怎么写？多谢
[/Quote]
同意

[fly0012008]

[Quote=引用 1 楼 sql77 的回复:]
SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB')
[/Quote]
同意

[--小F--]

select
 name 
from
 syscolumns 
where 
 name = '姓名' and id = object_id('成绩')