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...

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


Please Help Members By Posting Answers For Below Questions

How do you Implement SSIS Packages in your Project?

1980


What is the difference between clustered index and primary key?

968


How many triggers are possible per table?

1138


what are the disadvantages of cursors? : Sql server database administration

1078


Explain Normalization and DE normalization

1158


what is difference between view and Dip.

2456


How to use copy and concatenate commands in SQL?

1192


How to modify the underlying query of an existing view?

1027


What triggers long term care?

1083


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1565


What do you understand by the analysis services in sql server?

980


List the ways in which dynamic sql can be executed?

1057


What is the cpu pressure?

1105


what is a traditional network library for sql servers? : Sql server database administration

1009


How to convert a unicode strings to non-unicode strings?

1151