The Firebird 5.0 Language Reference | ALTER TABLE | The DROP DEFAULT And SET DEFAULT Clauses

The `DROP DEFAULT` and `SET DEFAULT` Clauses

The optional DROP DEFAULT clause deletes the current default value for the column.

If the column is based on a domain with a default value, the default value will revert to the domain default
An error will be raised if an attempt is made to delete the default value of a column which has no default value or whose default value is domain-based

The optional SET DEFAULT clause sets a default value for the column.If the column already has a default value, it will be replaced with the new one.The default value applied to a column always overrides one inherited from a domain.

`DROP TABLE`

Drops a table

Available in

DSQL, ESQL

Syntax

DROP TABLE tablename

Table 1. `DROP TABLE` Statement Parameter
Parameter	Description
tablename	Name (identifier) of the table

The DROP TABLE statement drops (deletes) an existing table.If the table has dependencies, the DROP TABLE statement will fail with an error.

When a table is dropped, all its triggers and indexes will be deleted as well.

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
);

The DROP DEFAULT And SET DEFAULT Clauses

The DROP DEFAULT and SET DEFAULT Clauses

DROP TABLE

docnext count = 4

Who Can Drop a Table?

Example of DROP TABLE

RECREATE TABLE

Example of RECREATE TABLE

The `DROP DEFAULT` and `SET DEFAULT` Clauses

`DROP TABLE`

Example of `DROP TABLE`

`RECREATE TABLE`

Example of `RECREATE TABLE`