Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    12

    Unanswered: sp_helpconstraint problem

    The BOL says that doing this:

    sp_helpconstraint Ref_mytable387

    will dump out details about the foreign key constraints above.
    However all I get is one row in the resultset with the column "Object name" with the content "Ref_mytable387" ?

    Is this a access security issue ? I'm logged in as "sa" in SQL2000. Thanks all.

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Well I have never played with this before so I just tried it out...

    When I run it against a table with constraints the first line is the object name line you meantioned then further down are the primary keys and foriegn keys that I have created...

    If I run it against a table without contraints then all I get is the first line as you meantioned....

    Does that help at all?? Are you sure the table you are checking has constraints??

  3. #3
    Join Date
    Nov 2003
    Posts
    12
    You know what, I think it's the DB query tool that's the problem. I'm not using Query Analyzer. And this tool is probably just returning the first resultset and left the rest out.
    Thanks.

  4. #4
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Yeah, that would probably do it.

Posting Permissions

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