ALTER TABLE EMP ADD CONSTRAINT EMP_PK PRIMARY KEY(EMPNO) DISABLE; Prim

how to create a primary key with out creating an index?

Question Posted / vinoth

9 Answers
21032 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / vinoth

ALTER TABLE EMP ADD CONSTRAINT EMP_PK PRIMARY KEY(EMPNO)
DISABLE;

Primary key constraint is created and no index is created
since the constraint is disabled initially.

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are sql queries used for?

1032

Which version of sql do I have?

1063

Does truncate free space?

1018

What is the purpose of a secondary key?

979

What is difference between sql and mysql?

1137

What operating systems are supported by oracle sql developer?

970

Explain table and field in sql?

1068

what is 'trigger' in sql? : Sql dba

1090

Why do we need cursor in pl sql?

1139

How do sql databases work?

1004

what is normalization? : Sql dba

1089

How is data stored on a disk?

1041

How to create a menu in sqlplus or pl/sql?

1129

What is pl/sql language case sensitive?

1132

How we can update the view?

1054