Automatically add "AS" before table alias

Hi all!

Is there any way to tell SA to put "AS" before aliases?

For example:
I need the following query

	Code:
	select * from MyTable

to be formatted like this

	Code:
	select * from MyTable as mt

Options dialog -> DB Options table -> select SQL Assistance type on the left -> Expand Auto complete ... section on the right. -> Auto Add Aliases from "Yes" to "Yes (with AS keyword)" -> click OK button

	SysOp wrote:
	Options dialog -> DB Options table -> select SQL Assistance type on the left -> Expand Auto complete ... section on the right. -> Auto Add Aliases from "Yes" to "Yes (with AS keyword)" -> click OK button

Thanks a lot!

Doesn't work with joins :(

Example:

	Code:
	select * from dbo.Contractors as c inner join dbo.Banks b on b.contractor_rid = c.record_id

After I wrote "inner join" I chose table name from the joins list. Table alias added without "as".

Thank you. I will log this issue to our support system

Olegon wrote:

Doesn't work with joins :(

Example:

	Code:
	select * from dbo.Contractors as c inner join dbo.Banks b on b.contractor_rid = c.record_id

After I wrote "inner join" I chose table name from the joins list. Table alias added without "as".

Strange indeed. It works properly when selecting the table from joins list but fails when selecting the join condition.