Database Manipulation Commands

To get started with database manipulation, see Creating and Modifying Table Structures in the Database Essentials section of the Developing Database Applications book and DF_FILE_PHYSICAL_NAME for examples of creating a new table. Structure_Start is the main command you will use for database manipulation.

Command Overview

Command Name	Purpose
Copy_Db	Used to copy a database table to or from a client or a server, or from one folder to another.
Create_Field	To add a column to the structure of a database table.
Create_Index	To create an index for a database table.
Delete_Db	Deletes a database table.
Delete_Field	To delete a column from the structure of a database table.
Delete_Index	To delete an index from the structure of a database table.
Field_Map	To return the field number of a given field of a database file.
Get_Attribute	To retrieve a global, driver, database/connection, table, column, or index attribute.
Get_FieldNumber	Returns the column number for the table and column passed as argument at compile time.
Get_FileNumber	Returns the file number for the file and field passed as argument at compile time.
Load_Def	Loads table-definition information from a sequential (.DEF) file into memory.
Load_Driver	Loads a database driver.
Make_File	To create a new, empty database table, or to modify the structure of an existing one.
Output_Aux_File	Outputs an auxiliary file (.FD or .DEF).
Set_Attribute	To set a global, driver, database/connection, table, column, or index attribute.
Structure_Abort	To terminate a table structure operation without completing it.
Structure_Copy	Copies the structure of one table to another.
Structure_End	Commits a structure operation, performing restructure on the table data if necessary.
Structure_Start	This command begins creation of a new table or modification of an existing one.
Unload_Driver	Unloads a loaded database driver.