--获取所有表名
select * from sysobjects where xtype='U' order by name
--获取所有字段名
select * FROM syscolumns where id=object_id('TableName')
select * from sysobjects where xtype='U' order by name
--获取所有字段名
select * FROM syscolumns where id=object_id('TableName')