|
I'd like to remove all default values that have been setup in a particular database, is there a script that I can run to do this for all tables in database? Could be a bit time consuming without ... any help would be appreciated!
(comments are locked)
|
|
Assuming you are on 2005+, and all your defaults are default constraints, and not bound defaults:
(comments are locked)
|
|
You can also use PowerShell: This script (running at the database level) will script and drop all default constraints.
(comments are locked)
|

