SQL Server Management Studio – Changing Default Data Type In Table Designer
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:
- Shrink Bloated Development Databases – Save Precious Space
- Execute Script Error Resolved In SQL Server Management Studio
- Easily Generate Table Change Scripts In SQL Server Management Studio
- Azure Databases – Restore Local Database To Azure
- Automate Standard Comment Blocks For New SQL Queries
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…)