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 is mutating trigger?

1024

Can a key be both primary and foreign?

995

What are the indexing methods?

1049

Describe types of sql statements?

1059

what are string data types? : Sql dba

1046

What is assignment operator in pl sql?

1038

What is the use of double ampersand (&&) in sql queries? Give an example

1139

What are sql triggers used for?

996

What is a trigger word?

1026

what is the use of friend function? : Sql dba

1023

Why we use sql profiler?

962

Explain the working of primary key?

1098

Explain raise_application_error.

1099

What is exit statement?

1019

What is the difference between local variables and global variables?

1125