c-treeDB API for C++ - Developers Guide

Creating a New Table

Creating a new table may be one of the most crucial operations performed by a database developer or administrator. The c-treeDB API offers a powerful, yet easy-to-use, mechanism for creating tables.

The create table process does not leave the table open after the table is created. The user must explicitly open the table to be able to add data records and query any of the table properties.

The create table process involves the following steps:

• Allocate a new table handle
• Add, insert, or delete fields
• Optionally, add, insert, or delete indexes
• Change any of the default table properties
• Create the table

In This Section Adding, inserting or deleting fields Fixed or variable length records Hidden fields Adding or deleting indexes Segment Modes ROWID index RECBYT index Changing default properties Creating the table Creating a table under transaction control