what is the use of composite key constraint?
Answers were Sorted based on User's Feedback
Answer / deva
its used to create a primary keys based on two or more
columns in the particular table.
By the set, those should be unique.
Is This Answer Correct ? | 14 Yes | 3 No |
Answer / srikanth
A composite key is used to club primary key for more than
once column.
PRIMARY KEY(<<COLUMN1>>,<<COLUMN2>>....<<COLUMNN>>)
But the disadvantage is that it will allow duplicates for
any one of the fields.
Example:
CREATE TABLE Example1
(Id INT NOT NULL,Pername VARCHAR(20) NULL,Phno INT NOT NULL
PRIMARY KEY(Id,Phno)
)
Command(s) completed successfully.
INSERT INTO Example1
VALUES(1,'sri',1111)
(1 row(s) affected)
INSERT INTO Example1
VALUES(1,'sri',6666)
(1 row(s) affected)
SELECT * FROM Example1
Id Pername Phno
1 sri 1111
1 sri 6666
As you can see that it is allowing same Id.
Basically Composite Key will take all the fields defined as
a group.So it is least bothered about any one of the field.
Is This Answer Correct ? | 8 Yes | 0 No |
How to define a record variable to store a table row?
How to drop an index?
does the query needs a hint to access a materialized view?
Do View contain Data ?
How to define default values for formal parameters?
Hi Can any one tell me what are the API's used in requisition import.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What happens if variable names collide with table/column names?
What is the exact use of Collections?
Can we create more than one constraint to column ?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
What is Database Link ?