SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
How to tell SQLAs not to insert brackets

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
How to tell SQLAs not to insert brackets
Author Message
SqlExplorer



Joined: 18 Sep 2011
Posts: 103
Country: United States

Post How to tell SQLAs not to insert brackets Reply with quote
I'm trying to type in the following code for Sql Server


IF EXISTS
(
SELECT
*
FROM
sys.objects
WHERE
OBJECT_ID = OBJECT_ID (N'tblWhatthe')

, etc., and I prefer not to use square brackets.

Unfortunately SqlAs is configured to insert square brackets for the second OBJECT_ID reference, thus:


OBJECT_ID = [object_id]

There is a parentheses configuration option, but nothing about square brackets. How do we turn off the square bracket generation?
Sun Dec 18, 2011 10:50 am View user's profile Send private message
SqlExplorer



Joined: 18 Sep 2011
Posts: 103
Country: United States

Post Reply with quote
Never mind. I can just hit the tab key, and it inserts only the object. Should have thought of that.
Sun Dec 18, 2011 11:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Actually, if you want to turn it off completely, open SQL Assistant Options, for SQL Server,
Go to DB Options tab
Select SQL Server in SQL Assistant section on the left
Expand Auto Complete group of options on the right
Change Always Add Delimiters option value to Never


In case you want to keep it but exclude certain names, do the following:
Go to Code Formatting tab
Select T-SQL Default Style section on the left
Expand Keywords group of options on the right
Scroll down to the bottom and locate section [Do not add delimiters]
Add keywords you don't want to be wrapped in delimiters


In both cases, restart the editor after the changes in order for the changes to take effect
Sun Dec 18, 2011 2:15 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.