SQL Prompt 6 EAP Synonym suggestion
Maurice
Posts: 14 Bronze 2
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.
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
Just did a check, works great now
Thanks !!!