| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_os_enumerate_fixed_drives (Transact-SQL) |
sys.dm_os_enumerate_fixed_drives enumerates volumes mounted to drive letters. |
rwestMSFT |
randolphwest |
05/11/2023 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-2016||>=sql-server-linux-2017||>=aps-pdw-2016||=azure-sqldw-latest |
Starting with [!INCLUDE sssql17-md] CU 1, sys.dm_os_enumerate_fixed_drives enumerates volumes mounted to drive letters like C:\.
| Column name | Data type | Description |
|---|---|---|
fixed_drive_path |
nvarchar(512) | Path to the volume, like C:\. |
drive_type 1 |
int | Code for drive type. |
drive_type_desc 1 |
nvarchar(512) | Description of drive type. |
free_space_in_bytes |
bigint | Disk free space in bytes. |
1 For more information, see the GetDriveTypeW function.
For [!INCLUDE sssql19-md] and previous versions, requires VIEW SERVER STATE permission on the server.
For [!INCLUDE sssql22-md] and later versions, requires VIEW SERVER PERFORMANCE STATE permission on the server.