Can u create a primary key with out unique index.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to raise user-defined exception with custom sqlerrm ?

863


When can we use the where clause and the having clause?

777


Can we use view in stored procedure?

698


What is the difference between truncate and drop statements?

763


Does mysql_real_escape_string prevent sql injection?

691






What is a full join?

706


What is a pl/sql block?

759


What does over partition by mean in sql?

707


What are some emotional triggers?

749


Is sqlexception checked or unchecked?

723


How can you fetch common records from two tables?

774


What is offset in sql query?

820


What is recursive join in sql?

752


explain the difference between myisam static and myisam dynamic. : Sql dba

705


How can you save or place your msg in a table?

709