When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to SQLite
none
DB2
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to DB2
none
MS Access
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to MS Access
none
PostgreSQL
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to PostgreSQL
none
Oracle
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to Oracle
CREATE OR REPLACE will remove an old VIEW exists.
It does not work with a TABLE :(
MS SQL Server
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to MS SQL Server
none
MySQL
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to MySQL
Does nothing if the table is already there.
Sybase
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).
Specific to Sybase
none
Mimer SQL
When developing table definitions it may be useful to precede
a sequence of CREATE TABLE statements with the corresponding DROP TABLE
statements in the reverse order (see next tip).