@Test
public void testAddSourcePrefixDropTable() throws Exception {

  String ddl =
      "DROP TABLE my_table_111, `another_table_222`, my_db.my_table_333, my_db222.`my_table000`, `my_db123`.my_table_444, `my_db_333`.`my_table_555`";
  String expectedDDL =
      "DROP TABLE my_table_111, `another_table_222`, `source/my_db`.`my_table_333`, `source/my_db222`.`my_table000`, `source/my_db123`.`my_table_444`, `source/my_db_333`.`my_table_555`";
  assertEquals(expectedDDL, schemaDatabase.addSourcePrefix(ddl));
  ddl = "DROP TABLE IF EXISTS `db123`.`table456`";
  expectedDDL = "DROP TABLE IF EXISTS `source/db123`.`table456`";
  assertEquals(expectedDDL, schemaDatabase.addSourcePrefix(ddl));
  ddl = "DROP TABLE ```escaped_backquotes``test_db:@fds!aaa`.`DFDS..``table``sss`";
  expectedDDL = "DROP TABLE `source/``escaped_backquotes``test_db:@fds!aaa`.`DFDS..``table``sss`";
  assertEquals(expectedDDL, schemaDatabase.addSourcePrefix(ddl));
}