What are different types of Keys? Please explain all the
keys with a suitable example.
- 4 Answers
- 26549 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
What stored by the master?
What is the function of sql server agent windows service?
Explain subquery and state its properties?
Difference between DELETE and TRUNCATE?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
How to provide values to user defined function parameters?
Explain the phases a transaction has to undergo?
What does it mean to invest in the index?
What is an index in sql?
What are ddl (data definition language) statements for tables in ms sql server?
What are entities and relationships?
How can I track the changes or identify the latest insert-update-delete from a table?
How do you create a data source?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
How to how to convert numeric expression data types using the convert() function??
