Difference between revisions of "ALTER TABLE ... ADD COLUMN"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
<div> | <div> | ||
This is in the SQL standard | This is in the SQL standard | ||
[http://sqlzoo.net/sql92.html#alter_table_statement ALTER TABLE] | |||
The term COLUMN is optional. | The term COLUMN is optional. | ||
</div> | </div> | ||
| Line 13: | Line 13: | ||
</source> | </source> | ||
<source lang='sql' class='def'>ALTER TABLE a ADD COLUMN z INTEGER | <source lang='sql' class='def'>ALTER TABLE a ADD COLUMN z INTEGER; | ||
SELECT * FROM a; | |||
</source> | </source> | ||
<source lang='sql' class='def e-sqlserver e-sybase'>ALTER TABLE a ADD z INTEGER | <source lang='sql' class='def e-sqlserver e-sybase'>ALTER TABLE a ADD z INTEGER; | ||
SELECT * FROM a; | |||
</source> | </source> | ||
<div class="ecomm e-db2" style="display: none"> | <div class="ecomm e-db2" style="display: none"> | ||
[https://aurora.vcu.edu/db2help/db2s0/frame3.htm#sqls0604 ALTER TABLE documentation.] | |||
ALTER TABLE documentation. | |||
DB2 seemingly does not permit this operation - any help would be appreciated. | DB2 seemingly does not permit this operation - any help would be appreciated. | ||
</div> | </div> | ||
| Line 27: | Line 28: | ||
</div> | </div> | ||
<div class="ecomm e-postgres" style="display: none"> | <div class="ecomm e-postgres" style="display: none"> | ||
[http://www.ca.postgresql.org/users-lounge/docs/7.0/user/sql-altertable.htm ALTER TABLE] | |||
</div> | </div> | ||
</div> | </div> | ||
{{CREATE and DROP ref}} | {{CREATE and DROP ref}} | ||
Latest revision as of 09:05, 18 July 2012
Add a column to a table
schema:scott
This is in the SQL standard ALTER TABLE The term COLUMN is optional.
DROP TABLE a
CREATE TABLE a(x INTEGER, y INTEGER);
INSERT INTO a VALUES (1,2);
ALTER TABLE a ADD COLUMN z INTEGER;
SELECT * FROM a;
ALTER TABLE a ADD z INTEGER;
SELECT * FROM a;