About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Tuesday, 18 October 2011

DIFFERENCE BETWEEN PRIMARY KEY AND UNIQUE KEY

One interest thing in sql is creation of primary and unique keys....

the difference between primary Key and Unique key is , Primary create clustered index on the column where as unique key creat non-clustered index on the column.

One major difference is primary Key doesn't allow NULL values but Unique allows One NULL value.

How interest it is..............


SQL is my passion.............i preferred SQL than any other RDBMS

No comments:

Post a Comment