Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

auto alias with full table name or allow rename for non-aliased names

This will interface beautifully with the rename option that is included with SQL complete. Frequently i'll copy code sets that use two different objects or start as table reads and later become a read from a temp table. being table to change the "from" and easily being able to the rename the alias/table to the new source and have all other references to it be updated as well would be great

3 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…)
Sduval shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
AdminDevart (_, Devart) responded  · 

Could you please provide us an example of this?

You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

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
  • Sduval commented  ·   ·  Report

    I have query 1 that I write to pull from one table:
    SELECT DNA.a
    ,DNA.b
    ,DNA.c
    ,DNA.d
    ,DNA.e
    ,DNA.f
    FROM dbo.DNA WITH (NOLOCK)

    Now I want to create query two (or just change query 1 to look at a different table with identical structure:
    SELECT DNA.a
    ,DNA.b
    ,DNA.c
    ,DNA.d
    ,DNA.e
    ,DNA.f
    FROM dbo.DNA_HISTORY WITH (NOLOCK)

    I’d love the ability to do this with query two:

    1. Either have the auto alias be able to replicate the full table name:
    a. FROM dbo.DNA DNA WITH (NOLOCK)
    i. So I can then press F2 and change the name to history
    a. FROM dbo.DNA DNA_HISTORY WITH (NOLOCK)
    c. Option 2 would be to just allow for the rename on the table name without an alias.

    Once the rename is complete I can remove the first DNA (from the second query) and leave just dbo.DNA_History now that all the column names have an updated table reference.