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
What is save transaction and save point?
What is a cursor, index in sql?
Explain intellisense for query editing
what is bit datatype? : Sql server database administration
Does the unique constraint create an index?
Explain what are sparse columns?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What are key constraints?
What is the purpose of optimization?
What are the steps you must follow to hide sql server instances?
Explain Reporting Life Cycle?
What are the different authentication modes in sql server? How can it be changed?
How to create a large table with random data for index testing in ms sql server?
How to use group functions in the select clause in ms sql server?
What are the types of user defined functions in sql server?