SQL Prompt 6 EAP Synonym suggestion

MauriceMaurice Posts: 14 Bronze 2
edited August 21, 2013 7:18AM in SQL Prompt Previous Versions
If the option Qualify column names with table name is enabled and a select statement is made with a synonym, then when the asterisk is expanded the table name is not the synonym name but the name of the table that is used when making the synonym.

When the synonym is called S and is made with table T you get the following statement:
SELECT T.name FROM S

Please correct this.

Comments

Sign In or Register to comment.