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

What are the different schemas objects that can be created using pl/sql?

1023

Can a table contain multiple foreign key’s?

995

Can we call dml statement in function?

1051

What is sql used for?

1124

How many developers work on postgresql?

976

What is AUTH_ID and AUTH_USER in pl/sql ?

2188

what is a composite primary key ? : Sql dba

1050

What is denormalization in a database?

1053

What is the mutating table and constraining table?

1026

Why triggers are used?

987

What is sql mysql pl sql oracle?

1067

What is difference between hql and sql?

1073

What is clustered index in sql?

1051

What do you think about pl/sql?

1027

What is scalar function in sql?

1038