Unique Data Columns in SQL Server 2005: A Quick Look

image_thumb

- Primary key
    -- Only one Identity column
    -- Can't be null

- Identity
    -- Automatic value
    -- Only one Identity column
    -- Can't be null
    -- Can exist in addition of primary key, GUID-auto columns

- Uniqueindentifier
    -- Can be multiple
    -- Can be null

- Uniqueindentifier - rowguid
    -- Auto generated
    -- Only one Identity column
    -- Can be null
    -- Can exist in addition of primary key, Identity columns

- Unique Key

    -- Can be null
    -- Can be multiple

Print | posted on Thursday, February 07, 2008 1:02 PM

Comments on this post

No comments posted yet.

Your comment:

 (will show your gravatar)
 
Please add 8 and 4 and type the answer here: