How can we help you today? How can we help you today?

Feature Qualify Object Names

Hello,

i have some question to the feature Qualify Object Names.

1. Why don`t SQL Refactor Qualify the column?

Example:
Source: SELECT col1 FROM table1
Formated by SQL Refactor: SELECT col1 FROM schema1.table1
Should be: SELECT t1.col1 FROM schema.table1 t1

2. It would be great if there would be an option to have the possibility to include the database in the Qualified Object name.

Example:
Source: SELECT col1 FROM table1
Should be: SELECT t1.col1 FROM database.schema.table1 t1

Cu
Atreju
Atreju
0

Comments

1 comment

Sort by
  • Andras B
    Atreju wrote:
    Hello,

    i have some question to the feature Qualify Object Names.

    1. Why don`t SQL Refactor Qualify the column?

    Example:
    Source: SELECT col1 FROM table1
    Formated by SQL Refactor: SELECT col1 FROM schema1.table1
    Should be: SELECT t1.col1 FROM schema.table1 t1

    2. It would be great if there would be an option to have the possibility to include the database in the Qualified Object name.

    Example:
    Source: SELECT col1 FROM table1
    Should be: SELECT t1.col1 FROM database.schema.table1 t1

    Cu
    Atreju


    Hi Atreju,

    this is a new suggestion we did not think about before. We will consider this for future releases (unfortunately not for version 1.0). If others like the idea, please respond to this post. The more response this idea gets, the more likely it will be in the following releases.

    Many thanks for this suggestion.
    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.