/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 vote138 views1 answer
Mysql read row
SQL
16 votes138 views1 answer
Sqlserver add column to table
SQL
0 vote153 views1 answer
Neo4j command to run script file
SQL
1 vote149 views1 answer
Display total number of tables in mysql
SQL
8 votes140 views1 answer
Sql limit results returned
SQL
0 vote148 views1 answer
Comma seperated join mssql
SQL
0 vote161 views1 answer
Sql server insert inner join
SQL
0 vote162 views1 answer
How to add mysql to path on termin after installation
SQL
2 votes135 views1 answer
Get first 2 letter in sql
SQL
0 vote136 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL