摘要:
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]oracle1、查找表的所有索引(包括索引名,类型,构成列):select t.*,i.index_typ 阅读全文