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
Tell me what is a linked server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How do I view a trc file?
Explain the concept of view and Types of views in SQL server?
What are the advantages of stored procedure in sql server?
How to handle error or exception in sql?
What are the source of constraints?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Difference between Logical Page and Physical Page in SSRS.
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to insert data into an existing table?
How does a profiler work?
How to fetch the next row from a cursor with a "fetch" statement?
How do you delete a trigger?
What is the benefit of normalization?