1、
SELECT sysobjects.name , syscolumns.name
FROM sysobjects ,syscolumns
WHERE (sysobjects.id = syscolumns.id)
2、
select col_name(OBJECT_ID('staff'),17)
3、
select name from syscolumns where id = object_id('你的表名');
1、
SELECT sysobjects.name , syscolumns.name
FROM sysobjects ,syscolumns
WHERE (sysobjects.id = syscolumns.id)
2、
select col_name(OBJECT_ID('staff'),17)
3、
select name from syscolumns where id = object_id('你的表名');