Method tableExistsQuery

src/dialects/db2/query-generator.js:178–186

(table)

  }

  tableExistsQuery(table) {
    const tableName = table.tableName || table;
    // The default schema is the authorization ID of the owner of the plan or package.
    // https://www.ibm.com/docs/en/db2-for-zos/12?topic=concepts-db2-schemas-schema-qualifiers
    const schemaName = table.schema || this.sequelize.config.username.toUpperCase();

    // https://www.ibm.com/docs/en/db2-for-zos/11?topic=tables-systables
    return `SELECT name FROM sysibm.systables WHERE NAME = ${wrapSingleQuote(tableName)} AND CREATOR = ${wrapSingleQuote(schemaName)}`;
  }

  dropTableQuery(tableName) {
    const query = 'DROP TABLE <%= table %>';