Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

automatic insert table alias on columns

when typing a query have the table alias inserted before the column automatically. For example, in the query below, the t. will automatically get inserted before the column names after the table with an alias is entered.

Select t.column1, 1.column2
from tablename t
where t.column1 = @value

22 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
mike 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
  • mike commented  ·   ·  Report

    This would really be useful when selecting the column names from the IntelliSense window, but you have a good point also.

  • Alexander commented  ·   ·  Report

    If there is a join across two aliased tables then I think it is a mistake not to add the alias to all the columns for the sake of clarity.
    A configuration option could be used to disable it for users who prefer the existing functionality.