@Test(expected = NoSuchObjectException.class)
  public void testDropTableNoSuchDatabase() throws Exception {
    Table table = testTables[2];

    client.dropTable("no_such_database", table.getTableName(), true, false);
  }
This test creates and queries a table and then drops it. Good for testing the happy path
standalone-metastore/metastore-server/src/test/java/org/apache/hadoop/hive/metastore/client/TestTablesCreateDropAlterTruncate.java