Creating and Restructuring Database Tables

Go Up to Understanding Databases and Datasets

You can use the TIBTable component to create new database tables and to add indexes to existing tables.

You can create tables either at design time, in the Forms Designer, or at runtime. To create a table, you must specify the fields in the table using the FieldDefs property, add any indexes using the IndexDefs property, and call the CreateTable method (or select the Create Table command from the table’s context menu). For more detailed instructions on creating tables, see Creating a table.

You can add indexes to an existing table using the AddIndex method of TIBTable.

Note:
To create and restructure tables on remote servers at design time, use the SQL Explorer and restructure the table using SQL.

Advance To:

• Using the Briefcase Model