Can u create a primary key with out unique index.

Answer Posted / ravin

Unique constraint and unique index are different things but
their goals might be similar.

Unique index is created implicitly with the creation of
Primary key and unique key both.
Hence no primary key can be created without a unique index.

Is This Answer Correct ?    19 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name three sql operations that perform a sort.

786


Explain the difference between rename and alias?

739


Explain clause in sql?

748


What is sql data?

706


Why sql query is slow?

729






Why truncate is faster than delete?

788


what does the t-sql command ident_current does? : Transact sql

733


How do I sort a table in sql?

765


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

864


What is a left inner join?

709


Which is better varchar or nvarchar?

732


What is an implicit commit?

761


what are the differences between require and include, include_once and require_once? : Sql dba

743


What is sql in oracle?

792


What are the uses of sysdate and user keywords?

844