Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are different types of Keys? Please explain all the
keys with a suitable example.

Question Posted / avishek patra

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


Please Help Members By Posting Answers For Below Questions

How is a full-text index updated?

896

What are the types of ssrs?

139

Define ACID properties in a Database?

1004

What is difference between getdate and sysdatetime in sql server 2008?

999

Why I am getting this error when dropping a database in ms sql server?

1021

What is query and its types?

871

How to implement service broker?

921

What is simple indexing method?

969

Can we do dml on views?

914

What is primary key and example?

896

Is the log file is a part of file group?

974

What is primary key, unique key, and foreign key?

915

What is difference between view and materialized view?

888

How to call a function from a stored procedure in SQL Server ?

952

How do I run a trace in sql server?

928