方法一:select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name=‘你的表名') 方法二:select 列名=name from syscolumns where id=object_id(N'你的表名'')
sql中获取表的列名
最新推荐文章于 2024-02-03 11:16:48 发布
方法一:select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name=‘你的表名') 方法二:select 列名=name from syscolumns where id=object_id(N'你的表名'')