code: def tables_in_schema(self, schema):
          
          sql = """SELECT table_name
                   FROM information_schema.tables
                   WHERE table_schema = %s"""
          return [t[0] for t in self.query(sql, (schema,)).fetchall()]
docs: Get a listing of all tables in given schema