/SQL/Sql server query database space available

Sql server query database space available

SELECT DB_NAME() AS DbName, 
    name AS FileName, 
    type_desc,
    size/128.0 AS CurrentSizeMB,  
    size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB
FROM sys.database_files
WHERE type IN (0,1);

Source: sqlshack.com

Similar codes

0 vote204 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote159 views1 answer
Code to move ietms from one table to another myswl
SQL
4 votes164 views1 answer
Oracle user tables
SQL
0 vote114 views2 answers
Postgresql could not start server mac
SQL
0 vote170 views2 answers
Get item by composite primary key mysql
SQL
3 votes222 views1 answer
Mysql group_concat distinct
SQL
2 votes167 views1 answer
Oracle percentage
SQL
14 votes155 views2 answers
Oracle limit rows
SQL
0 vote119 views0 answer
SQL
0 vote148 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL