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 are different types of database indexes?
What stored by the master? : sql server database administration
How to convert a table data in XML format in sql server?
How to add an address record into adventureworkslt?
How many types of triggers in sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?
Define Joins?
What is a database table?
Differentiate between sql temp table vs table variable?
which backup strategy you are following at ur company
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Difference between uniqe index and uniqe constraint?
Explain few examples of stored procedure over triggers?
What is the difference between having clause and where clause in sql server?
How to stop log file growing too big?