Easily Generate Table Change Scripts In SQL Server Management Studio
Something I found frustrating when designing databases, were the frequent changes made to tables. Managing the scripts can become quite tricky, especially if you are still in the design phase. This is made worse by code changes or change requests to existing data structures. Sometimes a person gets so caught up in the changes you need to make, that you forget about scripting these table changes.
Looking for something else? Try these links instead:
- Automate Standard Comment Blocks For New SQL Queries
- Azure Databases – Restore Local Database To Azure
- Execute Script Error Resolved In SQL Server Management Studio
- ApexSQL Provides Excellent SQL Tools For Free
- Query Stack Overflow With T-SQL – Give Your Queries A Workout
Here is a nice trick in SQL Server Management Studio to easily generate table change scripts. Never forget to script your changes again. (more…)