ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 393
SQL Statements A - D
DROP DBEFILE
DROP DBEFILE
The DROP DBEFILE statement removes the row describing a DBEFile from the
SYSTEM.DBEFile.
Scope
ISQL or Application Programs
SQL Syntax
DROP DBEFILE DBEFileName
Parameters
DBEFileName is the name of the DBEFile to be dropped.
Description
• Before dropping a DBEFile previously associated with a DBEFileSet via an ADD
DBEFILE statement, you must use the DROP INDEX and DROP TABLE statements to
empty the DBEFile, then use the REMOVE DBEFILE statement to remove the DBEFile
from the DBEFileSet.
• Although information for the dropped DBEFile is removed from the SYSTEM.DBEFile,
the file is not removed until the transaction is committed.
Authorization
You must have DBA authority to use this statement.
Example
CREATE DBEFILE ThisDBEFile WITH PAGES = 4,
NAME = 'ThisFile', TYPE = TABLE
CREATE DBEFILESET Miscellaneous
ADD DBEFILE ThisDBEFile TO DBEFILESET Miscellaneous
The DBEFile is used to store rows of a new table. When the table needs an index, one is
created.
CREATE DBEFILE ThatDBEFile WITH PAGES = 4,
NAME = 'ThatFile', TYPE = INDEX
ADD DBEFILE ThatDBEFile to DBEFILESET Miscellaneous