|
|
The DROP DBEFILESET statement removes the definition of a DBEFileSet
from the system catalog.
ISQL or Application Programs
DROP DBEFILESET DBEFileSetName
- DBEFileSetName
is the name of the DBEFileSet to be dropped.
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.)
You must have DBA authority to use this statement.
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
|