We are a software engineering firm. We use SQL Server Management Studio (SSMS) to generate the few scripts we need to build and upgrade our databases.
While it does an OK job, it bugs me that it insists on surrounding data types with []. So a column definition will be like:
[ID] [INT] IDENTITY(1,1) NOT NULL
while this just works, I don't like it because it does not distinguish the column name from its type in the script. Including syntax highlighting (everything is just black or your default font color). I was wondering if anybody had any idea on how to alter this behavior. We just want the output to be like:
[ID] INT IDENTITY(1,1) NOT NULL
Purchasing a specific tool is not an option at this time based on how much scripting we really do.
Thanks in advance for any help,
Eric.
Best Answer
I don't know of any setting which will do this in SSMS. Microsoft probably does it so that they don't need to check the data type name for special characters when generating the script (user defined data type names could have anything in them) so they just box everything.
You could submit that as a feature request to the tools team via connect.microsoft.com or to Mladen for including in his SSMS Tools Pack.