Deletes the specified file in the specified store.

Syntax

---

DELETE FILE <FileName> FROM STORE <StoreName>

Usage

---

Use this statement to delete the specified file in the specified store. The store may be either local or remote. The store must have already been created using the CREATE STORE statement.

Examples

---

-- This example deletes an update file
-- in a local store called OutUpdates

DELETE FILE "AccountingDB-Updates-2007-03-12.EDBUpd" FROM STORE "OutUpdates"

Required Privileges

---

The current user must be granted the DROP privilege on the store in which the file is being deleted. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: