OraFAQ Forum: SQL & PL/SQL » command to drop unique indexes

Home » SQL & PL/SQL » SQL & PL/SQL » command to drop unique indexes

Tue, 05 March 2002 01:53

Greg Horton
Messages: 37
Registered: February 2002

Member

Does anybody know what the command is to select and to drop all user defined UNIQUE_INDEX's?

Thanks :-)

Tue, 05 March 2002 02:14

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

1 find out all the unique index
select index_name
from user_indexes
where uniqueness='UNIQUE';
2. use "drop index index_name;" to drop the indexes

Previous Topic:	Find double ...
Next Topic:	what does error ORA-00001 mean?

Goto Forum:

]

Current Time: Fri Apr 19 02:47:48 CDT 2024