SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQL tutorial | Interview questions | Oracle

Database administration, oracle Interview questions, SQL Interview questions, DBMS Interview questions,SQL tutorial


Can You Drop an Index Associated with a Unique or Primary Key Constraint?

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

Go down

Can You Drop an Index Associated with a Unique or Primary Key Constraint? Empty Can You Drop an Index Associated with a Unique or Primary Key Constraint?

Post by Micheal Tue Jan 19, 2010 7:32 am

You can not delete the index associated with a unique or primary key constraint. If you try, you will
get an error like this: ORA-02429: cannot drop index used for enforcement of unique/primary key.

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

 
Permissions in this forum:
You cannot reply to topics in this forum