What are different types of Keys? Please explain all the
keys with a suitable example.
Answer Posted / avishek patra
There are mainly two types of keys are available in SQL server
1. PK
2. FK
1.PK-- In a Table the unique key(with no repetation and does
nota take null value) is called Primary Key
2.FK-- Foreign Key when that PK refers to another table then
its called as foreign Key
| Is This Answer Correct ? | 39 Yes | 42 No |
Post New Answer View All Answers
How do you Implement SSIS Packages in your Project?
What is the difference between clustered index and primary key?
How many triggers are possible per table?
what are the disadvantages of cursors? : Sql server database administration
Explain Normalization and DE normalization
what is difference between view and Dip.
How to use copy and concatenate commands in SQL?
How to modify the underlying query of an existing view?
What triggers long term care?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What do you understand by the analysis services in sql server?
List the ways in which dynamic sql can be executed?
What is the cpu pressure?
what is a traditional network library for sql servers? : Sql server database administration
How to convert a unicode strings to non-unicode strings?