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
- 14918 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 are the types of operators available in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What are the string functions in sql?
What is procedure function?
What is bulk collect in pl sql?
what is the difference difference between procedure and packages
Explain the components of sql?
What is the use of function "module procedure" in pl/sql?
Can we rollback truncate?
what are properties of a transaction? : Sql dba
What is sql and how does it work?
What is database migration?
How do you respond to dementia behavior?
What is a parameter query?
what is dbms? : Sql dba
