Go Up to Database Files
InterBase permits external files to be used as external tables. These tables are limited in their functionality:
- From a database that is in read-write mode, you can execute only
INSERTstatements on external tables. From a read-only database, you can execute only
SELECTstatement on external tables.
- You cannot define indexes on external tables; they are outside of the control of the multigenerational architecture.
- The 2GB external file size limit has been removed from InterBase XE onward.
The default location for external files is
<InterBase_home>/ext. InterBase can always find external files that you place here. If you want to place them elsewhere, you must specify the location in the
ibconfig configuration file using the
Migration note: If you are migrating from InterBase 6.x or older to InterBase 7.x or newer, and your database includes external table files, you must either move these files to
<InterBase_home>/ext or note their locations in
ibconfig using the