SQL Eval Function Directory_GetAllFileSystemEntries

Directory_GetAllFileSystemEntries returns the names of all files and subdirectories in a specified path.

Directory_GetAllFileSystemEntries (
	@path NVARCHAR (MAX))
RETURNS TABLE ([Match] NVARCHAR (MAX) NULL)

Parameters

  • path: The relative or absolute path to the directory to search. This string is not case-sensitive.

Returns

A list of the names of files and subdirectories in the specified directory, or an empty list if no files or subdirectories are found.

Example

SELECT * FROM Directory_GetAllFileSystemEntries('C:\Logs')

Contents