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 / sivasankar k.c

Primary key: it is clustered index. it not allows null
values. Only one primary in each table.

Unique Key: it is non clustered index. Unique key allows
null values.its allows only one null value. More than one
unique key in table.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can the query output be sorted by multiple columns in ms sql server?

934


How do I shrink an ldf file?

931


What are the new data types are introduced in sql 2000?

858


what is the difference between delete table and truncate table commands? : Sql server database administration

963


What is an index in sql?

959


What are the steps to insert a table?

891


How can we check the sql server version?

981


What happens on checkpoint?

966


What is a database in ms sql server?

991


What is the difference between coalesce() & isnull()?

1047


What are extended events in sql server?

903


What are the difference between clustered and a non-clustered index?

977


How to use wildcard characters in like operations in ms sql server?

1062


Explain a checkpoint?

975


What stored by the master?

903