Alan Fisher Alan Fisher -4 years ago 117
SQL Question

How to alter SQL Table default data type during design

I would like to change the default data type when designing a table in SQL Server Management Studio Table Designer. My current default is nchar(10) and I am creating a table with a lot of integer data types. I looked in Tools Options but could not find anyplace to change this. I'm running SQL Server 2008 R2.

Answer Source

It is possible, but requires a modification of the registry. This is a tiresome change to make every time you wish to change the default, so I agree with NYCdotNet.

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\DataProject

Screenshot of regpath

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download