1 根據資料庫名擷取所有表名
select name from sysobjects where xtype='u'
2 根據表名擷取所有列名
select name from syscolumns where id = object_id('HIS_OperationList');
select name from sysobjects where xtype='u'
select name from syscolumns where id = object_id('HIS_OperationList');