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 are the drivers in mysql? : Sql dba

563


What are synonyms in sql?

536


What is difference between function and trigger?

547


How do I turn a list into a table?

515


How to rename a table?

558






what is heap table? : Sql dba

612


Mention what plvcmt and plvrb does in pl/sql?

643


what is a trigger? : Sql dba

580


What is auto increment in sql?

590


Does a user_objects view have an entry for a trigger?

574


What do you understand by pl/sql packages?

573


Advantages and disadvantages of stored procedure?

583


What are pl sql data types?

553


how many values can the set function of mysql take? : Sql dba

539


Which software is used for pl sql programming?

526