Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

AS keyword

Include a formatting option to "Always include AS keyword for aliases". The goal would be to change

SELECT
*
FROM
[dbo].[Table1] [T]

into

SELECT
*
FROM
[dbo].[Table1] AS [T]

Note the AS added to the FROM clause. This option could be global (Misc group?) or could be a separate option for each relevant clause (SELECT for field names, FROM and JOIN for table names, etc.).

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Justin Watts shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Hi,

    Thanks for your patience!

    Please be informed that separate formatting options for AS in different positions of the select statement have been added.

    So we would like to suggest updating to the latest version and check there.
    Best,

    Devart Support Team