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

What is the beast way to write CTE in SQL Server ?

1093


What is the difference between upgrade and migration in sql server?

1145


Is it possible for a stored procedure to call itself or recursive stored procedure?

1003


List out a number of the wants to setup a SQL Server failover cluster?

1119


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

1022


What are the five major components of a dbms?

961


What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1067


How do you size a resultset?

962


What is failover clustering overview?

1137


What is dml command?

1018


what is the difference between Tabular and Matrix report?

179


How to disable a login name in ms sql server?

1170


What is the difference between implicit and explicit transaction?

1052


What is the concept of optimization?

1105


Explain filtered indexes?

1039