Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Unanswered: Check Constraint configuration

    Hi all,

    Where does SQL 2000 store all check-constraint configurations? i.e. I have a column in a table which I would like to limit the value to be > 10. Would like to retrieve the info via a client program.

    Thanks

    regards,
    tswern
    Save the dugongs!

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    all the constrainsts are saved in the table sysconstratints

  3. #3
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Unhappy

    looked into sysconstraints table. seems like it does not contain any rules I specified for my check contraint column. Only have a number of ids. Any idea which tables these ids tie to the actual check constraint configuration?
    Save the dugongs!

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    you might find this useful
    Attached Files Attached Files
    Paul Young
    (Knowledge is power! Get some!)

  5. #5
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Thumbs up

    Thanks paul! Indeed it is very usefull.
    Save the dugongs!

  6. #6
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Thumbs up

    Thanks paul! Indeed it is very usefull.
    Save the dugongs!

Posting Permissions

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