andyfrench.info

To find the constraints for  a given database column (without using the built-in SQL Managament Studio features) run the following SQL:

SELECT OBJECT_NAME(constid) 
FROM sysconstraints 
WHERE id = OBJECT_ID('table name here')
AND colid = 
    (
        SELECT colid 
        FROM syscolumns 
        WHERE id = OBJECT_ID('table name here') 
        AND name = 'column name here'
    )