/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

5 votes258 views2 answers
Sql server check port number
SQL
0 vote280 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote283 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote270 views1 answer
Mysql workbench view
SQL
0 vote269 views1 answer
Can't connect to postgresql mac os
SQL
2 votes276 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
1 vote280 views1 answer
How to lock table in mysql
SQL
4 votes262 views2 answers
REST API
SQL
0 vote247 views2 answers
Sql query unique
SQL
1 vote261 views2 answers
Sql drop multiple columns if exists
SQL