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 / suresh kaudi

Primary key : Not Accept null values
Unique key : Accept Onley one null value
When you Make Primary key In a table cluster index create
Automatically mean default.
Unique Key create Automatically non-cluster index

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about Joins?

930


How to reaname table name without using sp_Rename in sql server..?

935


What structure can you implement for the database to speed up table reads?

1154


What is index, cluster index and nonclustered index?

922


How to select all columns of all rows from a table with a select statement in ms sql server?

1044


How to download and install microsoft sql server management studio express?

971


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1084


What is a transactions?

970


Mention the differences between sql server and mysql.

946


Explain different types of Normalization.

1729


How to maintain a fill factor in existing indexes?

943


Explain different types of collation sensitivity?

921


What is snapshot parameter in ssrs?

138


Explain the difference between primary keys and foreign keys?

942


What are the advantages of using a stored procedure?

938