 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
SqlExplorer
Joined: 18 Sep 2011 Posts: 124 Country: United States |
|
How to tell SQLAs not to insert brackets |
|
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 |
|
 |
SqlExplorer
Joined: 18 Sep 2011 Posts: 124 Country: United States |
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|