Database file
Azure SQL DatabaseBelow is a script I commonly use to check for the free space in every file of a SQL Server database. The column headings are self-explanatory. Note that this can also be used for Azure SQL Database and Azure SQL Managed Instance.