(Contents)(Previous)(Next)

Column

The Column object identifies a column in a table. The names of the owner, table, and column are always required for its identification.

Relationships between a column and other objects:

1. Column Uses Column

2. Column Refers to Domain

3. Easycommand Uses Column

4. Easyform Uses Column

5. Foreignkey Uses Column

6. Index Uses Column

7. Module Uses Column

8. Qpcommand Uses Column

9. Qpquery Uses Column

10. Querycommand Uses Column

11. Snapshot Contains Column

12. Table Contains Column

13. User Uses Column

14. View Contains Column

1. A (VIEW) column uses a table column; a table column can be used as a view column (0-1).

2. A column can be defined by a DOMAIN; a DOMAIN can be used for a number of column definitions (N[0]-1).

3. An EASY command uses one or more table columns; a column can be used by a number of EASY commands (N[0]-M).

4. An EASY form uses one or more table columns; a column can be used by a number of EASY forms (N[0]-M).

5. A foreign key contains one or more table columns; a table column can be part of a foreign key (0-N).

6. An index comprises one or more table columns; a table column can occur in an index definition (0-N).

7. A module can use a number of table columns; a table column can be used in a number of modules (N[0]-M[0]).

8. A QueryPlus command uses one or more table columns; a table column can be used by a number of QueryPlus commands (N[0]-M).

9. A QueryPlus query uses one or more table columns; a table column can be used by a number of QueryPlus queries (N[0]-M).

10. A QUERY command uses one or more table columns; a table column can be used by a number of QUERY commands (N[0]-M).

11. A snapshot comprises one or more columns; a snapshot column is uniquely assigned to a snapshot (1-N).

12. A table comprises one or more columns; a column is uniquely assigned to a table (1-N).

13. A user can have access privileges for a number of table columns; a table column is used by one or more users (N-M[0]).

14. A view table comprises one or more columns; a view column is uniquely assigned to a view table (1-N).

A Column can be edited only within a table definition. However, it is also possible to list columns. Select design mode when a particular Column is selected to activate design mode for the associated table.


(Contents)(Previous)(Next)