|
<< Click to Display Table of Contents >> Tables |
  
|
|
<< Click to Display Table of Contents >> Tables |
|
Data in a database is organized in tables. A table name has meaning only within a database. Tables are accessible to the application in rows (records) and columns (fields). The rows can be ordered by an index.
To create a table, the application calls the Borland Database Engine (BDE) function DbiCreateTable passing the completed table descriptor structure CRTblDesc. Alternatively, tables can be created using SQL Data Definition Language (DDL).
Temporary Tables
Certain database operations create temporary tables that last only until you close them or end the BDE session. Your application can create two types of temporary tables:
•Use DbiCreateTempTable to create a temporary table, which can later be saved to disk. If the table becomes too large, it is automatically written to disk. The client application can explicitly save the temporary table to disk by calling the function DbiMakePermanent or DbiSaveChanges. For all practical purposes, these tables behave like regular tables.
•Use DbiCreateInMemTable to create a temporary table never intended to be written to disk. These tables are created by the application for gathering information that is needed temporarily during processing. These tables can be created only with logical types. These tables do not support indexes.
For detailed information, see:
•Accessing and updating tables