Mike,
You can use INFORMATION_SCHEMA view
SELECT * FROM pubs.INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
WHERE table_name = 'authors'
AND column_name = 'au_id'
>
>Is there a way to get the constraint of a particular column in a SQL Table?
>I need to check if a column containts a Constraint.
--sb--