table designer Archives ⋆ Programming and Tech Blog

Easily Generate Table Change Scripts In SQL Server Management Studio

Post author:Dirk Strauss
Post published:January 29, 2014
Post category:How To SQL
Post comments:4 Comments

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:

Here is a nice trick in SQL Server Management Studio to easily generate table change scripts. Never forget to script your changes again. (more…)

SQL Server Management Studio – Changing Default Data Type In Table Designer

Post author:Dirk Strauss
Post published:January 24, 2014
Post category:How To SQL
Post comments:2 Comments

If there is one thing that I always had a pet peeve with, was the table designer column data type default in SQL Server Management Studio. You have no option (that I am aware of) to change the default column data type when creating a new data table in table designer. SQL Server Management Studio decides that using ‘nchar’ is the way to go.

Looking for something else? Try these links instead:

Well if you want to make your columns another data type, you need to manually select the default value and change it to the data type you want. I wanted to find a way to change that default. Turns out that there is an easy way to accomplish this. (more…)