Product Documentation

Appearance

DROP EXTERNAL MOUNT ​

Drop an NFS mount that was used for external tables.

DROP EXTERNAL MOUNT [ IF EXISTS ] 'reference_name'

where reference_name is the name that was given to the mount when it was created. You must be a superuser to run this command.

Examples ​

premdb=# select * from sys.mounts;
       ref_name        |            resource            | options 
------------------------+--------------------------------+---------
 /local_external_tables | /home/brumsby/external_tables/ | {}
(1 row)
premdb=# drop external mount '/local_external_tables';
DROP EXTERNAL MOUNT

The following example demonstrates the use of the IF EXISTS syntax. The command does not return an error if the named mount does not exist. If it does exist, the mount is dropped.

premdb=# drop external mount if exists 'local';
DROP EXTERNAL MOUNT

Parent topic:SQL Commands