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?
Best Answer
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.