Primary key

Question

Hi Friends What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause ?

Pravin More · Answer

Hi Akash The index is created in the user's default tablespace and all sizing information is lost. database enviroment doesn't store this information as a part of the constraint definition but only as part of the index definition when the constraint was disabled the index was dropped and the information is gone. for more information.... read below successful discussion...... http://www.c-sharpcorner.com/Forums/Thread/149705/primary-key-constrain.aspx Thanks Pravin.