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 difference between primary key and Unique

Answer Posted / sunil kumar mishra

Primary key is a particular coloum that is unique in every
tuple is called primary key and ofenly it does not support
null values since it is used to uniquely identitfy row in a
table(Relation) and automatically does go to replace into
clustered index and support distinct value and Each table
should have a primary key, and each table can have only one
primary key.(Primary keys must contain unique values)

Unique value-
Unique values is same, in some manner, primary key since
You can have many UNIQUE constraints per table but primaty
key kan have one in each table.it support nonClustered
index.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between left and right outer join?

1063


How you can add messages to the nt event log from within a stored procedure?

1069


What is user-defined function?

979


You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1057


How to optimize stored procedure optimization?

894


What is update_statistics command?

1067


How to get a list of columns in a view using the "sp_columns" stored procedure?

1042


Explain differences between web edition and business edition?

119


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1044


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1046


How to achieve Paging of records in SQL SERVER?

1102


Do you know the cursor types?

1156


How exceptions can be handled in sql server programming?

1015


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1264


Explain the phases a transaction has to undergo?

1057