Yes,you can create primary key without creating unique index. Alter table

Can u create a primary key with out unique index.

Question Posted / nisith ranjan samal

Answer Posted / nisith ranjan samal

Yes,you can create primary key without creating unique index.
Alter table table_name add constraint constraint_name primary key(colum_name) disable

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I start pl sql?

899

What is trigger with example?

1015

Does a join table need a primary key?

904

How many types of index are there?

962

Is sql a dbms?

940

What is delimiter sql?

924

What is the difference between a primary key and a clustered index?

934

what is foreign key? : Sql dba

971

Define sql delete statement.

955

What is the difference among union, minus and intersect?

949

What is the difference between inner join and natural join?

956

explain primary keys and auto increment fields in mysql : sql dba

902

How to select random rows from a table?

1023

How does sql store data?

867

What is an example of translating a date into julian format?

1042