SQL SERVER TUTORIAL IN DEPTH

The blog is to help users about sql server

Others

LightBlog

Breaking

Saturday 16 November 2013

union key and primary key differences

1) Union key -- Creates non clustered index by default.
                     -- Can be set as null
                     -- Can have multiple unique key
                     -- Can be referenced by a foreign key

2) Primary key
                   --   Creates clustered index by default.
                     -- Can't be set as null
                     -- Can have only single primary key
                     -- Can be referenced by a foreign key

No comments:

Post a Comment

 test