Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Real easy one - list the constraints

    Hi,
    Trying to get all the constraints for particular Tables in my database. I try:

    SELECT constraint_name, constraint_type FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

    and getting nada?

    Any tips?

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Are you sure that there are constraints defined within your database?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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