分享到: 百度 更多
摘要: 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 阅读全文
posted @ 2012-09-13 13:09 黑马_Summer 阅读(186) 评论(0) 推荐(0) 编辑
分享到: 百度 更多