ALTER TABLE ... ADD COLUMN - Revision history

Marek at 09:05, 18 July 2012

2012-07-18T09:05:39Z

Marek at 14:10, 17 July 2012

2012-07-17T14:10:44Z

Marek at 14:01, 17 July 2012

2012-07-17T14:01:29Z

Marek at 15:37, 12 July 2012

2012-07-12T15:37:41Z

Marek: Created page with "Add a column to a table

schema:scott

Naturally, all of the data in the table is lost when the table is dropped. Foreign Key ref..."

2012-07-12T15:35:03Z

Created page with "Add a column to a table <div class='ht'> <div class=params>schema:scott</div> <div> Naturally, all of the data in the table is lost when the table is dropped. Foreign Key ref..."

New page

Add a column to a table
<div class='ht'>
<div class=params>schema:scott</div>
<div>
Naturally, all of the data in the table is lost when the table is dropped.

Foreign Key references can cause problems.
</div>

<source lang=sql class='tidy'>DROP TABLE a</source>
<source lang=sql class='setup'>CREATE TABLE a(x INTEGER, y INTEGER);
INSERT INTO a VALUES (1,2);
</source>

<source lang='sql' class='def'>ALTER TABLE a ADD COLUMN z INTEGER
</source>
<source lang='sql' class='def e-sqlserver e-sybase'>ALTER TABLE a ADD z INTEGER
</source>

<div class="ecomm e-db2" style="display: none">
<a href="https://aurora.vcu.edu/db2help/db2s0/frame3.htm#sqls0604">
ALTER TABLE documentation.</a>
DB2 seemingly does not permit this operation - any help would be appreciated.
</div>
<div class="ecomm e-sqlserver e-sybase" style="display: none">
Sybase and SQL Server do not permit the COLUMN keyword.
</div>
<div class="ecomm e-postgres" style="display: none">
<a href="http://www.ca.postgresql.org/users-lounge/docs/7.0/user/sql-altertable.htm">ALTER TABLE</a>
</div>
</div>
{{CREATE and DROP ref}}

@@ Line 4: / Line 4: @@
 <div>
 This is in the SQL standard
-<a href="http://sqlzoo.net/sql92.html#alter_table_statement">ALTER TABLE</a>
+[http://sqlzoo.net/sql92.html#alter_table_statement ALTER TABLE]
 The term COLUMN is optional.
 </div>

@@ Line 3: / Line 3: @@
 <div class=params>schema:scott</div>
 <div>
-Naturally, all of the data in the table is lost when the table is dropped.
+This is in the SQL standard
+<a href="http://sqlzoo.net/sql92.html#alter_table_statement">ALTER TABLE</a>
-Foreign Key references can cause problems.
+The term COLUMN is optional.
 </div>

@@ Line 21: / Line 21: @@
 <div class="ecomm e-db2" style="display: none">
-<a href="https://aurora.vcu.edu/db2help/db2s0/frame3.htm#sqls0604">
+[https://aurora.vcu.edu/db2help/db2s0/frame3.htm#sqls0604 ALTER TABLE documentation.]
-ALTER TABLE documentation.</a>
 DB2 seemingly does not permit this operation - any help would be appreciated.
 </div>
@@ Line 29: / Line 28: @@
 </div>
 <div class="ecomm e-postgres" style="display: none">
-<a href="http://www.ca.postgresql.org/users-lounge/docs/7.0/user/sql-altertable.htm">ALTER TABLE</a>
+[http://www.ca.postgresql.org/users-lounge/docs/7.0/user/sql-altertable.htm ALTER TABLE]
 </div>
 </div>
 {{CREATE and DROP ref}}