Question

sql server数据库：已知表明,怎么取到第一列的列明称？

Answer 1

执行查询
select * from 表名
结果中标题最前的（左边）就是第一列的名称

Answer 2

SELECT T.NAME AS TABLE_NAME
,C.NAME AS COLUMN_NAME
,EP.VALUE AS COMMENT
,C.COLUMN_ID
FROM SYS.TABLES T
,SYS.COLUMNS C
,SYS.EXTENDED_PROPERTIES EP
WHERE T.NAME = 'M_USER'
AND T.OBJECT_ID = C.OBJECT_ID
AND C.OBJECT_ID = EP.MAJOR_ID
AND C.COLUMN_ID = EP.MINOR_ID

这是'M_USER'表的所有字段和名称。如果要取第一个，直接再加一个条件 C.COLUMN_ID = 1

Answer 3

select top 1 name from syscolumns where id=(select id from sysobjects where name='表名')

Answer 4

如下：查询表名为tb_user的第一列列名
select top 1 name from syscolumns where id=object_id('tb_user')

如下：查询表名为tb_user的所有列列名
select name from syscolumns where id=object_id('tb_user')