Advisory: Support Portal Maintenance. Login is currently unavailable, more info available here.

Simple query to check if a folder exist

I know this may come off as a very basic question, but which table contains the list of all existing directories within an endpoint? 

I managed to come with this SQL query, but it only returns the folder if there is any file within the folder, hence the hash table.

FROM hash
directory = '$$folderPath$$'

Table directories doesn't exist, neither does table folders, so how do I simply check if a folder exists within a given path regardless if it contains files or not?

Thank you.

Changed formatting, added code section.
[bearbeitet von: intrusus um 8:34 PM (GMT -8) am 28 Nov 2020]