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

How to create database with physical files specified in ms sql server?

967


Can another user execute your local temporary stored procedures?

952


What are group functions in query statements in ms sql server?

962


Do you know what are the steps to process a single select statement?

928


What is difference between index seek vs. Index scan?

1104


What are the types of processing and explain each? : sql server analysis services, ssas

1115


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1021


what is difference between view and Dip.

2379


How many types of the database links?

1032


What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

945


Which rendering formats are affected by the pagesize properties?

138


What is the difference between grant and with grant while giving permissions to the user?

910


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

921


Is null in sql server?

955


Explain database normalization?

1163