Home » SQL & PL/SQL » SQL & PL/SQL » show index from table in oracle???
show index from table in oracle??? [message #263015] Tue, 28 August 2007 14:34 Go to next message
LAScorpion
Messages: 8
Registered: February 2007
Location: LA
Junior Member

mysql has the command show index from table1;
Would anybody tell me the equivalent in ORACLE?

thx,
Joseph

Re: show index from table in oracle??? [message #263019 is a reply to message #263015] Tue, 28 August 2007 14:39 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
What does the command do?
Re: show index from table in oracle??? [message #263021 is a reply to message #263015] Tue, 28 August 2007 14:42 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In Oracle, all is in table/view. Query user_indexes, all_indexes or dba_indexes.

Regards
Michel
Previous Topic: How to use switch case to run either of two select statements?
Next Topic: Accessing duplicate field name in a view
Goto Forum:
  


Current Time: Fri Dec 09 19:18:10 CST 2016

Total time taken to generate the page: 0.14304 seconds