当前位置: 代码迷 >> MySQL >> 查看mysql、sqlserver、oracle某个表的目录
  详细解决方案

查看mysql、sqlserver、oracle某个表的目录

热度:248   发布时间:2016-05-05 16:25:13.0
查看mysql、sqlserver、oracle某个表的索引

mysql

show index from v3x_affair;

sqlserver:

SELECT?? a.name,c.name,d.name
FROM?? sysindexes?? a??
JOIN?? sysindexkeys?? b?? ON?? a.id=b.id?? AND?? a.indid=b.indid??
JOIN?? sysobjects?? c?? ON?? b.id=c.id??
JOIN?? syscolumns?? d?? ON?? b.id=d.id?? AND?? b.colid=d.colid??
WHERE?? a.indid?? NOT IN(0,255)??
-- and?? c.xtype='U'?? and?? c.status>0 --查所有用户表??
AND?? c.name='v3x_affair' --查指定表??
ORDER BY?? c.name,a.name,d.name ;

oracle:

select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = 要查询的表

  相关解决方案