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

What is normalization process?

1105


When is update_statistics command used?

995


What is usually the first word in a sql query?

1068


Explain the dirty pages?

946


How to connect to a sql server using odbc_connect()?

1093


What is a livelock?

911


What number aggregate functions are accessible there in sql?

1004


Write the syntax for stuff function in an sql server?

976


How to retrieve field values using mssql_result()?

1184


What functions can a view be used to performed?

992


How to add a new dsn with the odbc driver for sql server?

1008


What is cdc in sql server?

950


How to view the error log for any specific instance? : sql server database administration

984


Explain index in sql server?

963


What function does a database engine serve in the sql server?

984