Difference between Unique key v/s Primary Key?

Difference between Unique key v/s Primary Key?

Postby jinideveloper » Fri Mar 09, 2012 3:21 am

What is the difference between Unique Key v/s Primary Key?
jinideveloper
 
Posts: 5
Joined: Wed Mar 07, 2012 2:41 am

Re: Difference between Unique key v/s Primary Key?

Postby pooja » Fri Apr 13, 2012 4:09 pm

primary key: 1.Does not allow null values 2.It creates a clustered index on the column by default
Unique key: 1.It allows only one null value in the column 2.It creates a non-clustered index on the column by default
pooja
 
Posts: 4
Joined: Wed Apr 11, 2012 1:43 am


Return to SQL | RDBMS | Database Queries

Who is online

Users browsing this forum: No registered users and 1 guest

cron