Adding or deleting media records, and modifying the description of file attributes
Using the utility statement ALTER MEDIA DESCRIPTION, the database administrator can modify the description of the file attributes in the media table for a database-specific file type. In addition, ALTER MEDIA DESCRIPTION can be used to add or delete media records in the media table.
Any modifications you make with ALTER MEDIA DESCRIPTION only affect new files of the specified file type. This statement has no effect on existing files.
Delete all the media records for a specific file type.
Using the utility statement DROP MEDIA DESCRIPTION, the database administrator can delete all the media records for a certain database-specific file type from the media table.
DROP MEDIA DESCRIPTION has no effect on files whose attributes are described in the media records that are to be deleted, i.e. existing files are not deleted.