List files in a folder recursively

Returns all files under the given path and every subfolder. Set Path and Recursive='true' to include nested files.

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