DBMS columns, column sets, and keys overview

Defines column, column set, and index key structures.

Description

The API has three key concepts: column, column set, and index key.

Column

A table in a database is defined by a set of columns. Each column has attributes such as a name, a type, and a maximum length (if text or binary).

A column definition is encapsulated by TDbCol.

Column set

A set of columns that describe a table are encapsulated in CDbColSet. The set can be iterated over using TDbColSetIter.

Index key

An index key orders one or more table columns (keys). It has attributes such as being unique or primary, a comparison specification for text columns, and a list of columns which make up the key.

The index key is encapsulated in CDbKey. A column for the key is encapsulated in TDbKeyCol.