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 / giri

unique:it does not allow duplicate values but it allow null values.
not null:It does not allow null values but allow duplicate values.
primary:It does not allow both duplicate and null values.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql the best database?

920


Is it mandatory for the primary key to be given a value when a new record is inserted?

1147


What is a variable in sql?

957


What are different clauses used in sql?

1083


How do I run a sql query in pgadmin 4?

911


What is pivot query?

1019


What is a heap in sql?

1001


What is the difference between join and natural join?

889


What is string join?

941


Can a key be both primary and foreign?

948


How do I sort a table in sql?

990


what is collation? : Sql dba

1085


Why do we use joins in sql?

919


Can variables be used in sql statements?

984


what is a scheduled jobs or what is a scheduled tasks? : Sql dba

920