| title | Database Properties (General Page) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 10/27/2015 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| f1_keywords |
|
||
| ms.assetid | 43080d43-8841-4807-baea-34a29b0fe663 | ||
| caps.latest.revision | 30 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
Use this page to view or modify properties for the selected database.
Last Database Backup
Displays the date that the database was last backed up.
Last Database Log Backup
Displays the date that the database transaction log was last backed up.
Name
Displays the name of the database.
Status
Displays the database state. For more information, see Database States.
Owner
Displays the name of the database owner. The owner can be changed on the Files page.
Date Created
Displays the date and time that the database was created.
Size
Displays the size of the database in megabytes.
Space Available
Displays the amount of available space in the database in megabytes.
Number of Users
Displays the number of users configured for the database.
Collation Name
Displays the collation used for the database. The collation can be changed on the Options page.
ALTER DATABASE (Transact-SQL)
ALTER DATABASE (Azure SQL Database)
sys.databases (Transact-SQL)
DATABASEPROPERTYEX (Transact-SQL)