CREATE TABLE problems: Table already exists.

From SQLZOO
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

CREATE TABLE problems: Table already exists.

schema:scott

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

CREATE TABLE t_holiday (a INTEGER)
CREATE TABLE IF NOT EXISTS
 t_holiday(a INTEGER)