SQLServer:获取表名,列名等信息

时间:2020-12-10 07:39:42

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

相关文章