SQL Eval Function Directory_GetAllDirectories

Directory_GetAllDirectories returns the names of subdirectories (including their paths) in the specified directory.

Directory_GetAllDirectories (
	@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 full names (including paths) of subdirectories in the specified path, or an empty list if no directories are found.

Example

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

Contents