Read all files and folders (recursive)

Gets all files and folders recursively in a single result set. Use when you need both file and folder items from the whole drive. To limit by path or drive, supply DriveId and SearchPath with the list_root or list_files table.

SELECT * FROM FilesFolders