def METHOD_NAME(self, schema=None):
    query = 'SELECT "TBL_NAME" from "TBLS" tbl'
    if schema:
        query += f""" JOIN "DBS" db on tbl."DB_ID" = db."DB_ID"
        and db."NAME" = '{schema}'"""
    return query