Example of DROP TABLE
COUNTRY
table.DROP TABLE COUNTRY;
DROP TABLE
COUNTRY
table.DROP TABLE COUNTRY;
RECREATE TABLE
Drops a table if it exists, and creates a table
DSQL
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.