tsunami

log in
history

SQL2005: script default constraints

Luke Breuer
0001-01-01 05:00 UTC

select  replace(replace(replace(
        'alter table ?table_name add constraint DF_?column_name default ?default_value for ?column_name'
        ,'?table_name', object_name(parent_object_id))
        ,'?column_name', col_name(parent_object_id, parent_column_id))
        ,'?default_value', dbo.RegexReplace(definition, '^(|)$', ''))
from    sys.default_constraints
where   parent_object_id = object_id('claim_charge')