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 = 要查询的表