Returns a list of folders as a table

  • Stored Procedure
  • SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017


EXEC @FolderPath


Name Type Description
@FolderPath varchar(MAX) Full path to an existing folder

Table Returned:

Column name Data type Description
RowID int Row Index
FolderName varchar(4000) The Name of the folder


Accessing the file system will be performed in the context of the SQL Server instance process. You can set SQL Server to run using a specific network account, or a Local System Account.

Sample Usage:

See Also: