FairCom DB API API for C# - Developers Guide

Altering a Table

The FairCom DB API .NET alter table function was designed and implemented to allow the modification of table, field and index properties after a table was created, and possibly already populated with data.

The usual steps to perform an alter table are:

• Add, insert, delete or edit fields
• Add, edit or delete indexes
• Alter the table by calling the CTTable.Alter() method

In This Section Add, Insert, Delete, or Edit Fields Add, Edit or Delete Indexes Alter the Table Deleting an Index from a Table Forcing an Index Rebuild Forcing a Table Rebuild