摘要： ms sql server1、查询所有表select [id], [name] from [sysobjects] where [type] = 'u' order by [name]2、查询所有数据库3、select [name] from [sysdatabases] order by [name]查询表中字段 select [name] from [syscolumns] where [name] = 'tableXXX'order by [colid]oracle 1、查找表的所有索引（包括索引名，类型，构成列）：select t.*,i.index_t 阅读全文