@staticmethod
def object_exists_stmt(schema_name: str, child_name='', table: bool=False,
    view: bool=False):
    """ Returns statement that, when executed, returns TRUE when the current object (of specified type) exists
        """
    if table or view:
        if table:
            sql_runner = 'tables'
        elif view:
            sql_runner = 'views'
        join = (
            f"JOIN sys.{sql_runner} o ON o.schema_id = s.schema_id AND o.name='{child_name}'"
            )
    else:
        join = ''
    return (
        f"EXISTS (SELECT 1 FROM sys.schemas s {join} WHERE s.name='{schema_name}')"
        )
