Synonym not always resolving

Maurice

Hi,

In SQL-Prompt 10 (10.0.1.12389) when using a synonym the fields or the name of the synonym are not always resolved when there is no alias.



Kind regards,

Maurice

Pete_Ruiz

Hello @Maurice ,

Thanks for reaching out and sorry that you're having trouble with SQL Prompt. I'm having a little trouble myself in trying to reproduce the issue. To clarify, is the alias called, "[PCD_NEDAP_RELATION]", actually an alias? If so, where is it defined? Also, can you kindly clarify how the synonym called "[dbo].[SE_PCD_NEDAP_RELATION]" relates to the alias that isn't being resolved? Would you mind sharing a sample script to assist in reproducing the issue that we can pass on to our development team for further review?

Kind regards,

Pete Ruiz

Redgate Product Support