Foreign Keys Editor (PostgreSQL)

From DBArtisan
Jump to: navigation, search

Go Up to PostgreSQL Object Editors

The Foreign Keys Editor lets you view or modify column mapping and properties for a foreign key.

To edit a foreign key

  1. Open an editor on the foreign key. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Column Mapping

Lets you work with the columns of the main table and mapped referenced table columns for this foreign key. For details, see Foreign Keys Wizard (PostgreSQL).

Properties

Lets you view or modify properties defined when creating the object. For details on these properties, see Foreign Keys Wizard (PostgreSQL).

Comment

For details on using this tab, see Adding a Comment to an object.

Dependencies

For details on using this tab, see Working with Object Dependencies.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.