Interested to Buy Any Domain ? << Click Here >> for more details...
What are different types of Keys? Please explain all the
keys with a suitable example.
- 4 Answers
- 27377 Views
- I also Faced
- E-Mail Answers
Answer Posted / rishit v chandarana
there are main 5 types of key, namely
candidate key,
primary key,
alternative key,
secondary key &
foreign key i.e refrential key.
Ck- all keys in a table.
Pk- selected key in a table.
Al- not selected as a pk key in a table.
Sk- not selected at all.
Rk- key showing refrence at other table.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Can the “if update (colname)” statement be used in a delete trigger?
What is nonclustered index with included columns ?
How to execute a stored procedure in ms sql server?
How to disable triggers using "disable trigger"?
how to invoke a trigger on demand? : Sql server database administration
What is the boxing and unboxing concept in .net?
What is xml datatype?
What happens if date-only values are provided as date and time literals?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is difference between commit and rollback when used in transactions?
How do you start single user mode in clustered installations?
plss anybody specify tha constrian management system in dbms
Explain the properties of sub-query in sql server?
What is Service Broker in sql server 2012?
What is a coalesce function?
