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

Answer Posted / priyankur

Unique constraint will always create non-clustered index on
column. so creation of Unique constraint is not the
solution. Yes, only sequence can create unique column but
that is not necessarily Primary key unless you treat it
likewise.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqlite used for?

528


What is oracle sql developer?

603


What is minus?

543


Is and as keyword in pl sql?

511


what are the different tables present in mysql? : Sql dba

502






How do you respond to dementia behavior?

532


is mysql query is case sensitive? : Sql dba

562


What is procedure in pl sql?

536


How many commands are there in sql?

545


What is the purpose of primary key?

529


What are the constraints available in sql?

580


Are null values same as that of zero or a blank space?

531


Describe sql comments?

559


Explain what is a database?

645


Where can I learn sql for free?

505