Gerrit Mantel
Programs SQL_SCALAR_FUNCTION - fun_DeleteFolder

Main program

Namefun_DeleteFolder
Type_descSQL_SCALAR_FUNCTION
CommentSQLServer User-Defined Function

PURPOSE
Delete given folder(s) (recursively).

Folders which are not empty can be deleted.
Folders which are readonly can be deleted.
Folders which contain readonly files can not be deleted.

Return value (INT):
0 = Success on delete folder(s)
negative integer = Failure on delete folder(s)

EXAMPLES
SELECT dbo.fun_DeleteFolder('C:\Temp\AAA');
SELECT dbo.fun_DeleteFolder('C:\Temp\A*');

HISTORY
2017-10-10 - Created function
2024-02-09 - Changed history table
2026-01-23 - Return retval from DeleteFolder

TAGS
<program>
<description>Delete given folder(s)</description>
<generic>1</generic>
<author>Gerrit Mantel</author>
<created>2017-10-10</created>
<lastmodified>2026-01-23</lastmodified>
</program>
DescriptionDelete given folder(s)
Minversion
Generic1
AuthorGerrit Mantel
Created2017-10-10 00:00:00
Lastmodified2026-01-23 00:00:00
Xp_cmdshell0
Ole_automation1
Subprogram_cnt0
Sourcecode