/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

8 votes133 views2 answers
Grant all privileges database postgres to user
SQL
16 votes118 views4 answers
Find duplicates mysql
SQL
0 vote126 views1 answer
Mysql regex select
SQL
-1 vote112 views2 answers
Get day in sql
SQL
0 vote122 views1 answer
Oracle service name view
SQL
0 vote119 views1 answer
Import Data in MySQL without using any other software
SQL
-1 vote115 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote120 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote80 views1 answer
Check id exist or not in sql
SQL
0 vote134 views1 answer
Sparql list all graphs
SQL