Interested to Buy Any Domain ? << Click Here >> for more details...
Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key
- 1 Answers
- 10692 Views
- I also Faced
- E-Mail Answers
Answer Posted / sapan saxena
Super Key: All possible keys which can identify entities in
the table uniquely.
Primary Key: uniquely identify each entity in the table and
does not contain null and duplicate vales.
Composite key: The combination of two or more than two keys
which identifies entities uniquely.
Candidate Key: Nominee for the primary key.
Alternate Key: Rest of the candidate keys which is not the
primary key.
Unique Key: Same as primary key but can accept one null key
only.
Foreign Key: A foreign key is one or more columns whose
value must exist in the primary key of another table.
| Is This Answer Correct ? | 41 Yes | 2 No |
Post New Answer View All Answers
What are different types of statement?
What are the different types of collation sensitivity in sql server?
What is tcl in sql server?
what is a self join? : Sql server database administration
Explain the difference between clustered and non-clustered index?
How to find the login name linked to a given user name?
What are the disadvantages of indexes?
What happens if you delete a table that is used by a view?
What are commit and rollback in sql?
What are data driven subscriptions?
Explain error handling in ssis?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What are the differences between union, intersect, and minus operators?
How you can add messages to the nt event log from within a stored procedure?
Why I am getting this error when dropping a database in ms sql server?
