Deletes a database from disk.

DELETE DATABASE DatabaseName | ? [DELETETABLES] [RECYCLE]

Parameters

DatabaseName

Specifies the name of the database to delete from disk. The database you specify cannot be open. DatabaseName can include the path to the database with the database name.

?

Displays the Delete dialog box from which you can specify the name of the database to delete from disk.

DELETETABLES

Deletes the tables contained in the database from disk and the database containing the tables.

RECYCLE

Specifies that the database isn't immediately deleted from disk and is placed in the Windows Recycle Bin.

Remarks

Example

This example creates a database named people. A table named friends is created and is automatically added to the database. DISPLAY TABLES is used to display the tables in the database, and DISPLAY DATABASES is used to display information about the tables in the database.

DELETE DATABASE is used with the DELETETABLES option to remove the database and its friends table from disk.

	Copy Code
CLOSE ALL CREATE DATABASE people CREATE TABLE friends (FirstName C(20), LastName C(20)) CLEAR DISPLAY TABLES && Displays tables in the database DISPLAY DATABASES && Displays table information CLOSE ALL DELETE DATABASE people DELETETABLES

See Also