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 are different types of raid levels?

1143


What is save transaction and save point?

1175


What is the difference between functions and scalar functions?

1189


How do I view a script in sql server?

1027


What is a view and what are its advantages?

1095


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

971


What is database architecture? : SQL Server Architecture

1018


Explain syntax for disabling triggers?

1022


Why is normalisation important?

927


What is difference between rownum and rowid?

884


What is indexed view? How to create it?

970


You want to implement the one-to-many relationship while designing tables. How would you do it?

939


what is a live lock? : Sql server database administration

938


How many types of the database links?

1053


Which table keeps information about stored procedures?

923