select * from syscolumns where id=object_id('table')
用下面的命令,把'表名'换成你自己的表名 select name from syscolumns where id=object_id('表名')善意的提醒:您的结帐率是0,这会影响许多人的回帖热情 如果认为我的答案是对的,请给分(虽然分很少),不对,请继续发问
select * from syscolumns where id=object_id('表名')
select * from syscolumns where id=object_id('表名')
create table t1(addname varchar(1),num int) insert t1 select 'a',1 union all select 'b',3select name from syscolumns where id=object_id('t1') name -------------------------------------------------------------------------------------------------------------------------------- addname num(所影响的行数为 2 行)
USER 数据库 GO select * from sysobjects where xtype='U'
select * from syscolumns where id=object_id('表名') 是这个吧
select name from syscolumns where id=object_id('表名')善意的提醒:您的结帐率是0,这会影响许多人的回帖热情
如果认为我的答案是对的,请给分(虽然分很少),不对,请继续发问
insert t1
select 'a',1 union all
select 'b',3select name from syscolumns where id=object_id('t1')
name
--------------------------------------------------------------------------------------------------------------------------------
addname
num(所影响的行数为 2 行)
GO
select * from sysobjects where xtype='U'