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 difference between primary key and Unique

Answer Posted / suresh kaudi

Primary Key: Not allow null values,when we make primary key
automatically create cluster index,primary key we make
other foreign key.

Unique key: allow one null value,we can't make it foreign
key to other table.here we cane make only non-cluster index

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define right outer join?

1013


What is the order in which the sql query is executed?

987


How to choose all records from the table?

1102


How to list all dsn entries on your local machine using odbc_data_source()?

1089


Why do we use sql limitations? Which constraints can we use while making a database in sql?

1121


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1038


How column data types are determined in a view?

1003


What is the difference between nvl and nvl2?

1024


What is user-defined scalar function?

1005


What is a cube? : sql server analysis services, ssas

1050


Tell me what is fill factor?

1007


What is transact-sql ddl trigger?

1146


What is sql server profiler trace data file?

1170


How can you find out which stored procedures are recompiling?

948


What is filestream?

1042