KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Is there some way to get a list of all the indexes on a particular table using SQL*Plus? I created a table CREATE TABLE temp( id NUMBER PRIMARY KEY, name VARCHAR2(20)); There should be an implicit index created on the primary key ( id ). How can I see that index? SELECT * FROM all_indexes WHERE table_name = 'temp'; gives no rows selected
Tags (comma-separated)
Save Edits
Cancel