Checking for synonym as PreCondition

General Discussion
1

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

2

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)