SQL Prompt 6 EAP Synonym suggestion

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt 6 EAP Synonym suggestion

Postby Maurice » Wed Aug 14, 2013 3:19 pm

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.
Maurice
 
Posts: 4
Joined: Wed Aug 14, 2013 2:57 pm

Postby Aaron Law » Thu Aug 15, 2013 10:46 am

Good catch! I can recreate this locally and will look into a fix for you.
Aaron Law
 
Posts: 260
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Aaron Law » Mon Aug 19, 2013 5:36 pm

This should now be fixed in 6.0.0.389.
Aaron Law
 
Posts: 260
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Maurice » Wed Aug 21, 2013 12:18 pm

Great ! Looking forward to the fix, I just love the synonym support!!!

Just did a check, works great now

Thanks !!!
Maurice
 
Posts: 4
Joined: Wed Aug 14, 2013 2:57 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests