select name from syscolumns where id=object_id('tablename')
比如 表A的字段有: A B C ,3个 显示的结果为 字段:表的字段 A B C
declare @col varchar(8000) select @col=isnull(@col,'')+name+char(13) from syscolumns where id=object_id('tablename')print @col
select name from syscolumns where id=object_id('A')
if object_id('tbtest') is not null drop table tbtest GO create table tbtest(id int,name varchar(10),age int) GO declare @colname varchar(4000) set @colname = '' select @colname = @colname + char(13) + name from syscolumns where id = object_id('tbtest') order by colorder ----在此指定显示顺序与列顺序一致 print @colnamedrop table tbtest
表A的字段有: A B C ,3个
显示的结果为
字段:表的字段
A
B
C
select @col=isnull(@col,'')+name+char(13) from syscolumns where id=object_id('tablename')print @col
drop table tbtest
GO
create table tbtest(id int,name varchar(10),age int)
GO
declare @colname varchar(4000)
set @colname = ''
select @colname = @colname + char(13) + name from syscolumns where id = object_id('tbtest')
order by colorder ----在此指定显示顺序与列顺序一致
print @colnamedrop table tbtest