List folders and files recursively

Lists all files and folders under the given path, including all nested subfolders. Set Recursive='true' and the folder Path to scan.

SELECT *
FROM list_folder
WITH (Path='/myfolder/subfolder'
     ,Recursive='true')