Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNIQUE CONSTRAINT and
PRIMARY KEY?
1. There is no difference.
2. A PRIMARY KEY cannot be declared on multiple columns.
3. A UNIQUE CONSTRAINT cannot be declared on multiple
columns.
4. A table can have multiple PRIMARY KEYS but only one
UNIQUE CONSTRAINT.
5. A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.
- 7 Answers
- 15214 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / vikneswaran
1) primary key don't allow null values but unique const
allow null values
2)we can declare primary key as multiple column. but table
should have one primary key
3)we can declare unique as multiple column. but table should
have one unique key
4) and 5)
in table we can create multiple column of primary key and
multiple column of unique. but only the restriction is in
table should have one primary key and one unique key .. if
it is neccessary.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What will you get by the cursor attribute sql%notfound?
What is the difference between row level and statement level trigger?
What is the difference between an inner and outer join?
What is a left join?
what is 'mysqlshow'? : Sql dba
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
what is timestamp in mysql? : Sql dba
Can procedure in package be overloaded?
What is a string data type in sql?
What is a join query?
How can you fetch common records from two tables?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is schema in sql?
How to order siblings in oracle hierarchy queries?
