Competition: What’s your favorite Redgate tool? Enter now.

SQL Prompt 6 EAP Synonym suggestion

MauriceMaurice Posts: 14 Bronze 1
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:

Please correct this.


Sign In or Register to comment.