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

What are properties of the transaction?

998


What is column?

992


What is the difference between a primary key and a clustered index?

993


What is trigger and stored procedure in sql?

1036


What is the difference between nvl function, ifnull function, and isnull function?

1113


How do you determine the current isolation level? : Transact sql

1158


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1100


Can we create clustered index without primary key?

964


Is left join inner or outer?

1015


How many unique keys can a table have?

1016


Does asenumerable execute the query?

1047


How many tables can you join in sql?

957


What is difference between joins and union?

1127


What is using in sql?

1094


How many aggregate functions are available there in sql?

984