1 根据数据库名获取所有表名
select name from sysobjects where xtype='u'
2 根据表名获取所有列名
select name from syscolumns where id = object_id('HIS_OperationList');
3 根据表名 获取列数
select count(name) from syscolumns where id = object_id('HIS_OperationList');