title: Liquibase: best way to check whether a table in a different database exists in <precondition>
body: <p>I have 2 databases: db 1 and db 2</p>
  
  <p>I need to take different action on db 1 based on whether a table in db 2 exists or not, and I am using liquibase to record my action.</p>
  
  <p>here is my solution so far</p>
  
  <pre><code>&lt;preconditions onFail="CONTINUE"&gt;
      &lt;sqlcheck expectedResult="1"&gt;
            IF EXISTS (SELECT 1 FROM DB2.INFORMATION_SCHEMA.TABLES 
                    WHERE TABLE_NAME = 'MY_TABLE') 
                    SELECT 1 ELSE SELECT 0
      &lt;/sqlCheck&gt;
  &lt;/precondition&gt;
  </code></pre>
  
  <p>The problem is: This is mssql syntax, if I try to use a different db, I need to change to use a different syntax, so what is the best way to do such thing?</p>