Browse Prior Art Database

Specification And Deletion of Database Table Foreign Keys

IP.com Disclosure Number: IPCOM000121025D
Original Publication Date: 1991-Jul-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 2 page(s) / 84K

Publishing Venue

IBM

Related People

Bracht, CJ: AUTHOR [+6]

Abstract

Disclosed is a visual method for providing an easy graphical interface for specifying, deleting, and modifying a database table's foreign keys, which are used in the enforcement of referential integrity.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Specification And Deletion of Database Table Foreign Keys

      Disclosed is a visual method for providing an easy
graphical interface for specifying, deleting, and modifying a
database table's foreign keys, which are used in the enforcement of
referential integrity.

      Referential integrity helps enforce data integrity within a
database system by setting constraints on database table values such
that all references from one table to another are valid and accurate.
Primary and foreign keys are used to establish these constraints.  A
key is an ordered set of table columns.  A primary key is composed of
one or more non-null columns and uniquely identifies each row in a
table.  A foreign key references a primary key, which may be in the
same table or a different table called the parent table.  The value
of each foreign key must match one of the values of the associated
primary key in the parent table.  A given table can have only one
primary key, but it can have many foreign keys.

      Since a database table may have many different aspects to its
definition, a visual representation called a notebook will be used
for organizing the related pieces of information into sections that
are easily obtained and viewed.  Each section of the notebook is
separated by a divider with a tab on it that identifies the section
and additionally serves as the first page of the section.  The
divider page for the foreign key section will contain a Foreign Key
Name entry field at the top, a scrollable list box of all currently
defined foreign keys, and at the bottom a GoTo button and a Delete
button.

      To view an existing foreign key definition, the user can select
the name of a foreign key in the list box, then press Enter, double-
click on the name, or press the GoTo button.  Wh...