 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
jrandall
Joined: 06 Oct 2008 Posts: 27 Country: United States |
|
4.0 beta data type formatting |
|
In SSMS, SQL Server 2005, data type names (int, char, varchar) are formatted like all other keywords (Upper Case for example). It would be nice if I could specify a separate format just for data type, i.e. lower case in DDL statements, variable and parameter declarations, etc.
e.g.
CREATE TABLE dbo.tablename (
col 1 int NOT NULL
,col2 varchar(10) NULL
)
rather than
CREATE TABLE dbo.tablename (
col 1 INT NOT NULL
,col2 VARCHAR(10) NULL
)
|
|
Fri Oct 10, 2008 12:16 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Method one: remove data types from keyword list and SQL Assistant will not format them . This is an easy change taking only a few seconds, but I don't recommend it as it might have side effects.
Method two: update keyword list and specify case for different keywords as you want it, for example all keywords but data types in upper case, all data types in lower case. This is also not difficult. If you copy the keyword list from options dialog into MS Word or other editor where you can easily run mass-case-change and then paste the modified list back into the Options. After that, change the value of keyword formatting option from Upper-case to Custom-case.
|
|
Fri Oct 10, 2008 1:25 pm |
|
 |
jrandall
Joined: 06 Oct 2008 Posts: 27 Country: United States |
|
|
|
That works great. Thanx
|
|
Fri Oct 10, 2008 1:49 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|