Viewing Database Schema Information

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

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. Use the (Microsoft Visual Studio) Properties window to view and change the design-time properties of selected objects that are located in Database Explorer.

To view additional schema information:

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

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

Object Viewer