What are different types of Keys? Please explain all the
keys with a suitable example.
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
How do I view a trc file?
Is truncate autocommit?
How do I partition a table in sql server?
What are cursors in ms sql server?
What is the use of builtinadministrators group in sql server? : sql server security
How to enter binary string literals in ms sql server?
List the ways in which dynamic sql can be executed?
What is de-normalization and what are some of the examples of it?
When we should use @@error?
Is sql server a database?
What are sql server procedures?
What is the template in sql?
What are the dmvs? : sql server database administration
What stored by the msdb? : sql server database administration
What are the export options of ssrs?