Scripts for getting Constraint Information

Hello there,
I need a sql query to get the constraint information from a sql server database / table.

Given a constraint name, I wish to know the following details.
the columns on which the constraint is based.
the table on which the constraint is based
the referenced table and columns on which the constraints are based in case of a foreign key constraint. Could you please help me?

I want this to workin case of Primary Key Constraint, Foreign Key Constraint and UNique Key COnstraint.

I am using sql server 7.0

Kind Regards,
Abhijit

Hi there,
i have got the solution to this one. Please don't reply me on this.

There is a stored proc called sp_helpconstraint 'table_name' which returns me a recordset.

Cheers!
Abhijit :)