Search
Submit a request
Sign in
How can we help you today?
Categories
Submit a request
Submit a request
Sign in
Support
Community
SQL Prompt Previous Versions
ignore character combos
New post
Our db has a table named AS_blahblah
but everytime I type
sum(colname) as
It keeps putting the tablename in there unless I am super speedy at typing.
Can I get it to ignore this?
austrianfoodispuke
August 15, 2008 05:18
-
0
+
Comments
1 comment
Sort by
Date
Votes
Thanks for your post.
If you uncheck the SQL Prompt option (SQL Prompt > Options > Inserted Candidates > Formatting) 'Qualify Column Names', then when you select the column name from the candidate list, it will not prefix the column with the table name or alias.
I hope this is helpful.
Chris Auckland
August 19, 2008 05:51
-
0
+
Add comment
Please
sign in
to leave a comment.
but everytime I type
sum(colname) as
It keeps putting the tablename in there unless I am super speedy at typing.
Can I get it to ignore this?