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

What are different types of database indexes?

1090


What stored by the master? : sql server database administration

1099


How to convert a table data in XML format in sql server?

2537


How to add an address record into adventureworkslt?

984


How many types of triggers in sql server?

1026


How to get a list of all tables with "sys.tables" view in ms sql server?

1030


Define Joins?

1023


What is a database table?

965


Differentiate between sql temp table vs table variable?

876


which backup strategy you are following at ur company

2143


What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1255


Difference between uniqe index and uniqe constraint?

969


Explain few examples of stored procedure over triggers?

1030


What is the difference between having clause and where clause in sql server?

1090


How to stop log file growing too big?

1012