/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 vote334 views1 answer
Show all mongodb
SQL
0 vote391 views3 answers
Java hide mysql login credentials
SQL
0 vote333 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote399 views1 answer
Oracle list user locked
SQL
1 vote358 views1 answer
Error code 1292 mysql workbench
SQL
0 vote436 views1 answer
Redshift running queries
SQL
0 vote360 views1 answer
Android sqlite add column if not exists
SQL
36 votes367 views3 answers
Finding duplicate column values in table with sql
SQL
21 votes367 views4 answers
Add column mssql
SQL
0 vote386 views1 answer
Dual in db2
SQL