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');