怎么取出一个sql数据库中的某个表的所有字段名

[qianjunyi]

怎么取出一个sql数据库中的某个表的所有字段名
如：数据库Trade中的表System_Info

[pbsql]

select name from Trade.dbo.syscolumns where id=object_id(N'System_Info')

[zjcxc]

select 字段名=name from Trade.dbo.sysobjects where name='System_Info'

[zjcxc]

--如果要取到变量中
declare @s varchar(8000)
set @s=''
select @s=@s+','+name from Trade.dbo.sysobjects where name='System_Info'
set @s=stuff(@s,1,1,'')
print @s

[enewren]

select * from syscolumns where id in(select id from sysobjects where name ='tablename' and xtype='u')

[afanyun]

select name from dbo.syscolumns
where id=(select id from dbo.sysobjects where name='System_Info')

[afanyun]

--如果要取到变量中

declare @s varchar(8000)
set @s=''
select @s=@s+','+name from dbo.syscolumns where id=(select id from dbo.sysobjects where name='System_Info')
set @s=stuff(@s,1,1,'')
select @s

[lzymagi]

select * from database..dbo.syscolumns where id=object_id('tablename')

[qizhanfeng]

学习了
select * from database..dbo.syscolumns where id=object_id('tablename')

[葶子宝贝]

exec sp_columns 'tablename'
该语句可以显示出此表的所有信息