22,209
社区成员
发帖
与我相关
我的任务
分享
列出表里的所有的列
select name from syscolumns where id=object_id('TableName')
select a.name from sys.columns a inner join sys.objects on a.id=b.id and b.type='U'
select
object_name(object_id) 'table_name',
name 'column_name'
from sys.columns
where name='[字段名]'
select a.name from sys.columns a inner join sys.objects where a.id=b.id and b.type='U'
select name from sys.objects where object_id in(select object_id from sys.columns where name='a')