/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 vote168 views1 answer
Luu ckeditor vao mysql
SQL
0 vote167 views1 answer
Tsql delete all rows
SQL
0 vote228 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote191 views1 answer
T sql dynamic top n query
SQL
0 vote166 views1 answer
Order by ip address sql
SQL
1 vote279 views1 answer
Adding a check statement in sql
SQL
0 vote165 views1 answer
Oracle sql procedure return value
SQL
0 vote228 views1 answer
Sql commands in android
SQL
4 votes201 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote154 views1 answer
Lister les index d'une table oracle
SQL