• Chirag (2/14/2008)


    Hi

    You can use information_schema.table_constraints.

    Have you ever tried this for a Default Value Constraint?

    I can't find any trace of the constraint in question within that schema anywhere. Even doing a search just based on table name, all I see is the PKey, no other constraints.....and I know that the constraint exists because after using the table_constraint search and finding no trace of the constraint I get a 'Column already has a DEFAULT bound to it' when trying to add it.