NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Functions > FS.GetDirectoryInfo

Dependencies for Assembly (CLR) table-valued function: Util.FS.GetDirectoryInfo

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.FS.GetDirectoryInfo	Assembly (CLR) table-valued function	Util.UtilClr	ASSEMBLY	1	[Util].[UtilClr]

Assembly (CLR) table-valued function: Util.FS.GetDirectoryInfo

CREATE FUNCTION [FS].[GetDirectoryInfo]
(@path NVARCHAR(4000), @filter NVARCHAR(4000))
RETURNS TABLE (
    [Name] NVARCHAR(4000) NULL,
    [IsDirectory] BIT NULL,
    [SizeGB] NUMERIC(20, 2) NULL,
    [SizeMB] NUMERIC(20, 2) NULL,
    [Size] BIGINT NULL,
    [CreateDate] DATETIME NULL,
    [LastWritten] DATETIME NULL,
    [LastAccessed] DATETIME NULL,
    [Attributes] NVARCHAR(4000) NULL
)
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [UtilClr].[UtilClr.FileSystemFunctions].[GetDirectoryInfo]

Description for Assembly (CLR) table-valued function: Util.FS.GetDirectoryInfo

Todo