方法一:
select * from syscolumns where (id in (select id from sysobjects where name = 'tbl'))
select * from syscolumns where (id in (select id from sysobjects where name = 'tbl'))
方法二:
select * from INFORMATION_SCHEMA.COLUMNS where (TABLE_NAME = 'tbl')