Details for logical drives on the system. A logical drive generally represents a single partition.
|device_id||TEXT||The drive id, usually the drive name, e.g., ‘C:’.|
|type||TEXT||The type of disk drive this logical drive represents.|
|free_space||BIGINT||The amount of free space, in bytes, of the drive.|
|size||BIGINT||The total amount of space, in bytes, of the drive.|
|file_system||TEXT||The file system of the drive.|
|boot_partition||INTEGER||True if Windows booted from this drive.|
select * from logical_drives
select free_space from logical_drives where device_id = 'C:'