I'm setting up a database in SQL-2014 that is exchanging data with a mainframe. All the fields are char, so there are trailing spaces. In table designer, my default field type is varchar.

Is there a way to change this one database so the default field type will be char as I create new tables?

  • The default column data type in the SSMS table designer is not configurable. Is that the table designer are you referring to? – Dan Guzman Jul 10 '16 at 13:54

The default column data type in the SQL Server Management Studio table designer is not currently configurable. If this feature is important to you, consider submitting a suggestion on Connect. Be sure to specify why the feature has value to you and your organization (e.g. enhanced productivity).

The default type is configurable in the Visual Studio IDE, though. In VS 2015, the option is available under Options-->Database Tools-->Table and Database Designers-->Column Options.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.