Generate script for Default Value or Binding in SQL Server

Question

Recently I set value for Default Value or Binding to (newid()) in table design.

Now I want to generate scripts for the changes to execute on another database.

Can anyone please help me to write/generate script for these changes.

Thanks in advance!

Note: I have checked this solution but not helped me coz I want to generate script for all the tables in which I have made changes recently for Default Value or Binding

Possible duplicate of How to set a default value for an existing column — Paul M
– Paul M, Commented Jan 31, 2017 at 9:59

Pரதீப் · Accepted Answer · 2017-01-31 10:13:21Z

3

Use the below query to generate the script for default constraints with default value newid()

SELECT 'alter table ' + Quotename(o.name)
       + ' add constraint ' + Quotename(dc.name)
       + ' default ' + dc.definition + ' for '
       + Quotename(c.name)
FROM   sys.default_constraints dc
       INNER JOIN sys.columns c
               ON dc.parent_object_id = c.object_id
                  AND dc.parent_column_id = c.column_id
       INNER JOIN sys.objects o
               ON o.object_id = dc.parent_object_id
WHERE  definition = '(newid())'

copy paste the result in new database and execute it create the default constraints.

edited Jan 31, 2017 at 10:13

answered Jan 31, 2017 at 10:06

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generate script for Default Value or Binding in SQL Server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related