ALLBASE/SQL Reference Manual > Chapter 10 SQL Statements A - D

DROP DBEFILESET

	MPE documents
	Complete PDF
	Table of Contents
	Index

	E0300 Edition 9 ♥
	E0399 Edition 8
	E0897 Edition 7

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

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

DROP DBEFILE

DROP GROUP