Share via

How to: View or Change the Properties of a Database (SQL Server Management Studio)

This topic describes how to view a database by using Object Explorer in SQL Server Management Studio.

To view a database

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand Databases, right-click the database to view, and then click Properties.

  3. In the Database Properties dialog box, select a page to view the corresponding information. For example, select the Files page to view data and log file information.

    For a description of each option, see Setting Database Options.

See Also