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

In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.

Primary key uses clustered index where are unique +Not null uses non clustered index.

Sreekumar

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963


What is clustered index sql?

985


What is trigger in pl sql?

1003


Explain alias in sql?

1051


Can dml statements be used in pl/sql?

1081


What is the unique index?

1054


What is dml with example?

1089


What is sql query limit?

980


What is sql lookup?

920


Mention what is the use of function "module procedure" in pl/sql?

1049


What is the difference between a database and a relational database?

1103


What is the difference between left join and right join?

946


Explain raise_application_error.

1098


What is flag in sql?

1036


What is percent sign in sql?

1283