ALLBASE/SQL Reference Manual (36216-90216)

396 Chapter10
SQL Statements A - D
DROP DBEFILESET
When the index is subsequently dropped, its file space can be assigned to another
DBEFileSet.
REMOVE DBEFILE ThatDBEFile FROM DBEFILESET Miscellaneous
CREATE DBEFILESET OtherDBEFileSet
ADD DBEFILE ThatDBEFile TO DBEFILESET OtherDBEFileSet
The following statement allows you to use ThisDBEFile to store an index later, if you need
one.
ALTER DBEFILE ThisDBEFile SET TYPE = MIXED
If, later, all rows are deleted from the table, you can reclaim file space.
REMOVE DBEFILE ThisDBEFile FROM DBEFILESET Miscellaneous
DROP DBEFILE ThisDBEFile
If it is
not a default DBEFileSet, you can now drop its definition.
DROP DBEFILESET Miscellaneous