• This should get you started. If you want to know the column to script it out you can use the parent_column_id and join to sys.columns.

    SELECT OBJECT_NAME(parent_object_id) AS TableName, name AS DefaultName,*

    FROM sys.default_constraints