How to obtain constraint info

[djohannsen@yahoo.com]

i need to programmaticall y obtain and the process constraint
information. the problem with the output from sp_helpconstrai nt is
that it outputs two resultsets. (the 2nd resultset is exactly what i
need though)

as far as i know i can't stick this output into a temp table to then
process with cursors or anything like that. i'm trying to directly
access all kinds of sytem tables but not getting the complete info that
the 2nd resultset that sp_helpconstrai nts offers.

(E.g. sp_helpindex is more useful as it outputs only one resultset of
information so i could programmaticall y use that output to do what i
need to do)

any suggestions? thanks.

[djohannsen@yahoo.com]

Re: How to obtain constraint info

i'm a dork, ignore this.

to get a single resultset out of sp_helpconstrai nt just follow the
help. ugh.

specifying nomsg as last parm suppresses the tablename from coming out,
so i can use the resultset now.