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

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Thursday, February 07, 2008 1:02 PM

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: