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
- 27259 Views
- I also Faced
- E-Mail Answers
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
explain databases and sql server databases architecture? : Sql server database administration
What will be the maximum number of index per table?
What does the update command do?
What is the most common trace flags used with sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What do you mean by data integrity?
What is the difference between SQL notification and SQL invalidation?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How many types of objects are there?
Do you know what is lock escalation?
do you know how to configure db2 side of the application? : Sql server database administration
What is difference in performance between insert top (n) into table and using top with insert?
Write down the syntax and an example for create, rename and delete index?
Is foreign key unique?
Explain error and transaction handling in sql server?
