What are the challenges you face when working across database platforms? Take the survey

Synonym not always resolving


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

Kind regards,



  • Options
    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
Sign In or Register to comment.