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
0

Comments

1 comment

  • Chris Auckland
    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
    0

Add comment

Please sign in to leave a comment.