What are the challenges you face when working across database platforms? Take the survey
Options

Alias adds additional alias incorrectly

hafnerahafnera Posts: 16 New member
edited April 27, 2016 6:12AM in SQL Prompt
I really like the feature for auto aliasing tables, but I noticed an issue where if I have a table that already is aliased and then change the table it generates another alias instead of replacing the old alias. For example:
/*Start with this*/
SELECT
Field1 
FROM Table1 AS t1

/*delete table name and change to Table2, then this happens*/
SELECT
Field1
FROM Table2 AS t2 AS t1

It should either use the existing alias or it should change the alias to the new suggested alias for the new table. If it changes the alias it should also update fields that had the previous alias to now reference the new alias. This may cause issues if the new table doesn't have the same tables, but intellisense should identify which fields needs to be changed.

Comments

  • Options
    Ali DAli D Posts: 56 New member
    Hi

    Thanks for your suggestion, the best place to log it would be on our UserVoice forum which we use to help track and prioritise new features (plus you'll get notified when we have a new build ready, along with anyone else who's also interested).

    Thanks
    Ali
Sign In or Register to comment.