获得列名
select name from syscolumns where id=object_id('tb_user')
或
select col_name(object_id('table'),1) from sysobjects where name='table'
--读取库中的所有表名
select name from sysobjects where xtype='Warehouse_management_system'
--读取指定表的所有列名
select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='表名')
SQL 获取列名
最新推荐文章于 2024-07-13 03:00:20 发布