SQLServer、Oracle获取数据库、表、表里字段、类型、注释
SQLServer:
--获取所有非系统数据库
select name from master..sysdatabases where name not in('master', 'model', 'msdb', 'tempdb', 'northwind', 'pubs', 'ReportServer', 'ReportServerTempDB')
--获取某个表的详细字段信息
select c.name,t.name,c.prec,p.value from syscolumns c
inner join systypes t on c.xtype= t.xtype
inner join sysobjects o on c.id= o.id
inner join sys.extended_properties p on c.id = p.major_id and c.colid = p.minor_id
where o.xtype='u'and t.status=0 and o.name='表名'
--获取所有表信息
select * from sysobjects where XType='U'
--字段信息