Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Check Constraint?

    In SQL Server 2000, I want to apply a check constraint on a column type varchar that it is not duplicated. Could someone help me out with this?

    Also, should I just make this column the primary key instead of an identity field being the primary key?

    What is the performance difference by applying the constraint rather then just making it the primary key?

    Mike B

  2. #2
    Join Date
    Jul 2003
    The Dark Planet
    Try using a unique constraint !!
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts