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.

SELECT
directory
FROM hash
WHERE
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.