ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 395
SQL Statements A - D
DROP DBEFILESET
DROP DBEFILESET
The DROP DBEFILESET statement removes the definition of a DBEFileSet from the system
catalog.
Scope
ISQL or Application Programs
SQL Syntax
DROP DBEFILESET DBEFileSetName
Parameters
DBEFileSetName is the name of the DBEFileSet to be dropped.
Description
• Before you can drop a DBEFileSet, you must use the REMOVE DBEFile statement to
remove any DBEFiles associated with the DBEFileSet.
• You cannot DROP a default DBEFileSet. You must first change the default to some other
DBEFileSet.
• DROP also removes any authorities associated with the DBEFileSet. (Refer to syntax for
the GRANT statement with the ON DBEFILESET clause.)
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 as follows:
CREATE DBEFILE ThatDBEFile WITH PAGES = 4,
NAME = 'ThatFile', TYPE = INDEX
ADD DBEFILE ThatDBEFile to DBEFILESET Miscellaneous