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 the different between unique+not null & primary key,

Answer Posted / mohan babu

A unique key is nothing but it does not allow any
duplicateds but allows nullvalues

A primary key is nothing but it does not allow duplicates
as well as Null values i.e Not Nulls

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different tcl commands in sql?

1162


explain commit and rollback in mysql : sql dba

1003


How can one get sql*loader to commit only at the end of the load file? : aql loader

1049


Why do we need sharding?

982


Can a composite key be null?

970


What's the procedure?

920


What is rank dense_rank and partition in sql?

1020


what is a constraint? : Sql dba

1138


Explain the uses of a database trigger?

1031


What is meant by temporal data?

959


How to assign sql query results to pl sql variables?

1066


What is cartesian join in sql?

1107


what is sql in mysql? : Sql dba

1182


Is it possible to sort a column using a column alias?

1034


explain the options of myisamchk to improve the performance of a table. : Sql dba

1001