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
- 27413 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
Can you explain full-text query in sql server?
What do you mean by an execution plan?
How many database files are there in sql server 2000?what are they?
How do I save a stored procedure in sql server?
Write a sql query to get zero records from a table having n number of records?
What command do we use to rename a database?
What is normalization? Explain different forms of normalization?
Is foreign key a primary key?
Explain optimistic and pessimistic concurrency?
Explain cursor as data base object?
How can you control the amount of free space in your index pages?
How can I get data from a database on another server?
Explain system scalar functions?
How you can get the list of largest tables in a database?
What is enhanced database mirroring in sql server 2008?
