Removes a table from the current database.

REMOVE TABLE TableName | ? [DELETE] [RECYCLE]

Parameters

TableName | ?

Specifies the table to remove from the current database or displays the Remove dialog box so you can choose a table in the current database to remove.

[DELETE]

Removes the table from the database and deletes it permanently from disk.

Caution noteCaution

Tables deleted using the DELETE keyword cannot be retrieved. Visual FoxPro does not confirm deletion or provide a warning even if the SET SAFETY command is set to ON.

[RECYCLE]

Specifies to delay deleting the table from disk and moves it to the Windows Recycle Bin.

Expand imageRemarks

Expand imageExample

Expand imageSee Also