NuRoN Consulting, INC.

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

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

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

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

CREATE FUNCTION [FS].[GetFileInfo]
(@path NVARCHAR(4000))
RETURNS TABLE (
    [FileName] NVARCHAR(4000) NULL,
    [Directory] NVARCHAR(4000) 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].[GetFileInfo]

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

Todo