The Firebird 5.0 Language Reference | DROP TABLE

Who Can Drop a Table?

The DROP TABLE statement can be executed by:

Administrators
The owner of the table
Users with the DROP ANY TABLE privilege

Example of `DROP TABLE`

Dropping the COUNTRY table.

DROP TABLE COUNTRY;

`RECREATE TABLE`

Drops a table if it exists, and creates a table

Available in

DSQL

Syntax

RECREATE [GLOBAL TEMPORARY] TABLE tablename
  [EXTERNAL [FILE] 'filespec']
  (<col_def> [, {<col_def> | <tconstraint>} ...])
  [{<table_attrs> | <gtt_table_attrs>}]

See the CREATE TABLE section for the full syntax of CREATE TABLE and descriptions of defining tables, columns and constraints.

RECREATE TABLE creates or recreates a table.If a table with this name already exists, the RECREATE TABLE statement will try to drop it and create a new one.Existing dependencies will prevent the statement from executing.

Example of `RECREATE TABLE`

Creating or recreating the COUNTRY table.

RECREATE TABLE COUNTRY (
  COUNTRY COUNTRYNAME NOT NULL PRIMARY KEY,
  CURRENCY VARCHAR(10) NOT NULL
);

Who Can Drop A Table?

Who Can Drop a Table?

Example of DROP TABLE

RECREATE TABLE

Example of RECREATE TABLE

Example of `DROP TABLE`

`RECREATE TABLE`

Example of `RECREATE TABLE`