Dropping a store will delete all of the files present in the store along with the store directory if the store is a local store. However, you can keep the files but remove the store from the configuration by specifying the KEEP CONTENTS clause.
-- The following statement drops the Backups store.
DROP STORE "Backups"
Required PrivilegesThe current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.
SQL 2003 Standard DeviationsThis statement deviates from the SQL 2003 standard in the following ways: