/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

-1 vote189 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote192 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote176 views1 answer
Ms sql filter all sympbol
SQL
0 vote154 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote164 views2 answers
Plan d'exécution requete oracle autotracer
SQL
3 votes166 views3 answers
How to add month in update sql
SQL
3 votes178 views1 answer
Oracle sleep
SQL
0 vote213 views1 answer
Select year from dual oracle
SQL
0 vote180 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote186 views1 answer
Mysql exception output
SQL