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