SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
4.0 beta data type formatting

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
4.0 beta data type formatting
Author Message
jrandall



Joined: 06 Oct 2008
Posts: 27
Country: United States

Post 4.0 beta data type formatting Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
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 View user's profile Send private message
jrandall



Joined: 06 Oct 2008
Posts: 27
Country: United States

Post Reply with quote
That works great. Thanx
Fri Oct 10, 2008 1:49 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.