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's the difference between a primary key and a unique key?

Answer Posted / hameed

Primary key does not allow any null value in a table where
as Unique key allows only one null value

Primary key is by default a Clustered Index where as Unique
key is a non-clustered index

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1066


Explain different types of collation sensitivity?

982


What is a DBMS, query, SQL?

1047


How to attach adventureworkslt physical files to the server?

1106


what do you understand by change data capture?

1024


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

976


How do you delete a trigger?

982


What is sql server management studio? : sql server management studio

1075


What is the template in sql?

979


What is the use of commit?

1001


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1050


How to list all triggers in the database with sys.triggers in ms sql server?

1083


What is join query?

895


How to receive returning result from a query?

1126


How to make a column nullable?

1115