Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → RECREATE TABLE
Firebird Home Firebird Home Prev: RECREATE PROCEDUREFirebird Documentation IndexUp: DDL statementsNext: RECREATE TRIGGER

RECREATE TABLE

Tip

Find a more recent version at Firebird 5.0 Language Reference: TABLE

Available in: DSQL

Added in: 1.0

Description: Creates or recreates a table. If a table with the same name already exists, RECREATE TABLE will try to drop it (destroying all its data in the process!) and create a new table. RECREATE TABLE will fail if the existing table is in use.

Syntax: Exactly the same as CREATE TABLE.

Prev: RECREATE PROCEDUREFirebird Documentation IndexUp: DDL statementsNext: RECREATE TRIGGER
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → RECREATE TABLE