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 is Primary key and foreign key? Give an example

Answer Posted / brajesh kumar srivastava

Primary key enforce uniqueness of column and deny to allow
null values to this column and enforce referential data
integrity constraint to other table column which is call
foreign key.
Foreign key column may contain null value

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the different ways to return the rowcount of a table?

978


What is named query? : sql server analysis services, ssas

948


How to enter comments in transact-sql statements?

925


What are the types of resultset?

952


Why functions are used in sql server?

939


What is the difference between getdate and sysdatetime?

988


What is isnull() operator?

1018


What is the difference between a primary key and a unique key? Are they the same?

1058


how many no of arguments can be passed in procedures and functions

5529


What are the extra roles available in msdb? : sql server security

1110


Why is the need for data conversion transformations?

1033


How do I find the sql server database version?

986


if no size is defined while creating the database, what size will the database have? : Sql server administration

976


Explain raiserror in sql server?

997


Explain few examples of stored procedure over triggers?

1012