Checking for synonym as PreCondition

is there a way to check for the existence of a synonym in a PreCondition clause?

synonymExists clause would be an awesome solution for this problem.

So I’m looking for an alternate approach. I haven’t been able to find anything in the doc or forums indicating how one can handle conditions involving synonyms.

Thanks!
Mark

Hello,

You can use the sqlCheck from the preConditions tag, here is an example with the verification of an existing constraint:

  1.        
               
                    SELECT COUNT(*) FROM USER_CONSTRAINTS U
                    WHERE U.TABLE_NAME = ‘TABLE_NAME’
                    AND U.CONSTRAINT_NAME = ‘CONSTRAINT_NAME’
               
           

I hope this will be of some help ;o)