/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

16 votes181 views3 answers
Order by sql query
SQL
0 vote144 views1 answer
Sql last 7 days
SQL
0 vote158 views1 answer
SQLServerException.makeFromDatabaseError
SQL
28 votes145 views4 answers
Show tables mysql
SQL
5 votes144 views2 answers
Update all rows mysql
SQL
0 vote132 views1 answer
How to get employee having maximum experience in mysql
SQL
1 vote143 views1 answer
Apex ORA-20999
SQL
0 vote165 views2 answers
Sqlalchemy default value for column
SQL
1 vote161 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote136 views1 answer
Clone table structure mysql
SQL