Viewing Database Schema Information

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

Edit Column Shortcut

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:
  3. Select a required object in the Database Explorer window.
  4. In the View menu, click Properties (or press F4). To view additional schema information:
  5. Select a required schema in the Database Explorer window.
  6. 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.

Object Viewer