Marek at 10:06, 17 July 2012

2012-07-17T10:06:54Z

Marek at 10:06, 17 July 2012

2012-07-17T10:06:10Z

Marek: Created page with "Rename column

schema:scott

DROP TABLE a CREATE TAB..."

2012-07-17T10:05:16Z

Created page with "Rename column <div class='ht'> <div class=params>schema:scott</div> <div> </div> <source lang=sql class='tidy'>DROP TABLE a</source> <source lang=sql class='setup'>CREATE TAB..."

New page

Rename column
<div class='ht'>
<div class=params>schema:scott</div>
<div>
</div>

<source lang=sql class='tidy'>DROP TABLE a</source>
<source lang=sql class='setup'>CREATE TABLE t_test
(a INTEGER NOT NULL PRIMARY KEY
,b VARCHAR(10)
)</source>

<source lang='sql' class='def e-mysql'>DROP TABLE a;
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);

ALTER TABLE a CHANGE x y INTEGER;
SELECT * FROM a
</source>
<source lang='sql' class='def e-access'>CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);

ALTER TABLE a RENAME COLUMN x TO y;
SELECT * FROM a
</source>
<source lang='sql' class='def e-postgres'>CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);

ALTER TABLE a RENAME COLUMN x TO y;
SELECT * FROM a
</source>
<source lang='sql' class='def e-oracle'>CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);
ALTER TABLE a RENAME COLUMN x TO y;
</source>
<source lang='sql' class='def e-sqlserver'>USE scott;
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);

sp_rename 'a.x', 'y', 'COLUMN';
SELECT * FROM a;
</source>
<source lang='sql' class='def e-sqlite'>Not possible
</source>
<source lang='sql' class='def'>CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);

ALTER TABLE a RENAME COLUMN x TO y;
SELECT * FROM a
</source>

<div class="ecomm e-sqlite" style="display: none">It is not possible to remove a column in SQLite.</div>
<div class="ecomm e-mysql" style="display: none">
The stored procedure [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ra-rz_3ns5.asp sp_rename] will do this.

Thanks to Mike Wasson, Orlando, Florida
</div>
<div class="ecomm e-mysql" style="display: none">[http://sqlzoo.napier.ac.uk/big/B/s/a/statements_32a.htm#2054899 ALTER TABLE]</div>
</div>
{{CREATE and DROP ref}}

@@ Line 8: / Line 8: @@
 <source lang=sql class='setup'></source>
-<source lang='sql' class='def e-mysql'>DROP TABLE a;
+<source lang='sql' class='def e-mysql'>
 CREATE TABLE a(x INTEGER);
 INSERT INTO a VALUES (2);

@@ Line 6: / Line 6: @@
 <source lang=sql class='tidy'>DROP TABLE a</source>
-<source lang=sql class='setup'>CREATE TABLE t_test
+<source lang=sql class='setup'></source>
- (a INTEGER NOT NULL PRIMARY KEY
- ,b VARCHAR(10)
- )</source>
 <source lang='sql' class='def e-mysql'>DROP TABLE a;

Rename column - Revision history

Marek at 10:06, 17 July 2012

Marek at 10:06, 17 July 2012

Marek: Created page with "Rename column schema:scott DROP TABLE a CREATE TAB..."

Marek: Created page with "Rename column

schema:scott

DROP TABLE a CREATE TAB..."