NuRoN Consulting, INC.

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

Dependencies for SQL inline table-valued function: Util.FS.GetVolumeInfo

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.FS.GetVolumeInfo	SQL inline table-valued function	Util.FS.GetVolumeInfo_CLR	Assembly (CLR) table-valued function	1	[Util].[FS].[GetVolumeInfo_CLR]
Util.FS.GetVolumeInfo_CLR	Assembly (CLR) table-valued function	Util.UtilClr	ASSEMBLY	2	[Util].[FS].[GetVolumeInfo_CLR], [Util].[UtilClr]

SQL inline table-valued function: Util.FS.GetVolumeInfo

CREATE FUNCTION [FS].[GetVolumeInfo]()
RETURNS TABLE
AS
RETURN
SELECT
    CAST(Volume AS VARCHAR(128)) AS Volume,
    CAST(Label AS VARCHAR(128)) AS Label,
    CapacityGB,
    FreeGB,
    CapacityMB,
    FreeMB,
    Capacity,
    FREE,
    FreePercent,
    CAST(BootVolume AS VARCHAR(128)) AS BootVolume,
    CAST(SystemVolume AS VARCHAR(128)) AS SystemVolume,
    CAST(FileSystem AS VARCHAR(128)) AS FileSystem
FROM [FS].[GetVolumeInfo_CLR]()

Description for SQL inline table-valued function: Util.FS.GetVolumeInfo

Todo