How to view schema information in Database Explorer

Last modified: October 1, 2024

You can view, edit, create and drop database objects by using the Database Explorer window.

As other users modify the database, you can refresh the list of database objects displayed in the Database Explorer window and their properties by clicking the Refresh button.

To rename a database object:

1. Select a required object in the Database Explorer window.
2. Press the F2 key or click it again after a short pause.

To view a database object properties:

1. Select a required object in the Database Explorer window.
2. In the View menu, click Properties (or press F4).

To view additional schema information:

1. Select a required schema in the Database Explorer window.
2. In the View menu, click Object Viewer.

You can double-click tables, views, procedures, functions, triggers, events, UDFs folders in Database Explorer and the Object Viewer window will open automatically.

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!