Removes a table from the current database.
Syntax
REMOVE TABLE TableName | ?
[DELETE] [RECYCLE]
Arguments
TableName
Specifies the table to remove from the current database.
?
Displays the Remove dialog box from which you can choose a table in the current database to remove.
DELETE
Specifies that the table is removed from the database and from disk.
Caution Any table deleted from disk with this clause cannot be retrieved. Even if SET SAFETY is ON, you are not warned before the table is deleted from disk.
RECYCLE
Specifies that the table isn't immediately deleted from disk and is placed in the Windows 95 Recycle Bin.
Remarks
When a table is removed from the database, it becomes a free table and can be added to another database. Tables are added to a database with ADD TABLE.
When REMOVE TABLE is issued, all primary indexes, default values, and validation rules associated with the table are also removed. If SET SAFETY is ON, Visual FoxPro displays a prompt asking if you are sure you want to remove the table from the database.
Important REMOVE TABLE affects other tables in the current database if those tables have rules or relations associated with the table being removed. The rules and relations are no longer valid when the table is removed from the database.