CREATE TABLE problems: Table already exists. - Revision history

Marek at 09:27, 17 July 2012

2012-07-17T09:27:31Z

Marek at 09:26, 17 July 2012

2012-07-17T09:26:30Z

Marek: Created page with "CREATE TABLE problems: Table already exists.

schema:scott

When developing table definitions it may be useful to precede a sequ..."

2012-07-17T09:26:10Z

Created page with "CREATE TABLE problems: Table already exists. <div class='ht'> <div class=params>schema:scott</div> <div> When developing table definitions it may be useful to precede a sequ..."

New page

CREATE TABLE problems: Table already exists.
<div class='ht'>
<div class=params>schema:scott</div>
<div>
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).
</div>

<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def'>CREATE TABLE t_holiday (a INTEGER)
</source>
<source lang='sql' class='def'>CREATE TABLE IF NOT EXISTS
t_holiday(a INTEGER)
</source>

<div class="ecomm e-mysql" style="display: none">Does nothing if the table is already there.</div>
<div class="ecomm e-oracle" style="display: none">CREATE OR REPLACE will remove an old VIEW exists.
It does not work with a TABLE :(</div>
</div>
{{CREATE and DROP ref}}

@@ Line 11: / Line 11: @@
 <source lang='sql' class='def'>CREATE TABLE t_holiday (a INTEGER)
 </source>
-<source lang='sql' class='def'>CREATE TABLE IF NOT EXISTS
+<source lang='sql' class='def e-mysql'>CREATE TABLE IF NOT EXISTS
   t_holiday(a INTEGER)
 </source>

@@ Line 3: / Line 3: @@
 <div class=params>schema:scott</div>
 <div>
-When developing table definitions it may be useful to precede
+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).
-  a sequence of CREATE TABLE statements with the corresponding DROP TABLE
-  statements in the reverse order (see next tip).
 </div>

CREATE TABLE problems: Table already exists. - Revision history

Marek at 09:27, 17 July 2012

Marek at 09:26, 17 July 2012

Marek: Created page with "CREATE TABLE problems: Table already exists. schema:scott When developing table definitions it may be useful to precede a sequ..."

Marek: Created page with "CREATE TABLE problems: Table already exists.

schema:scott

When developing table definitions it may be useful to precede a sequ..."