Difference between revisions of "Rename column"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
<source lang=sql class='setup'></source> | <source lang=sql class='setup'></source> | ||
<source lang='sql' class='def e-mysql'> | <source lang='sql' class='def e-mysql'> | ||
CREATE TABLE a(x INTEGER); | CREATE TABLE a(x INTEGER); | ||
INSERT INTO a VALUES (2); | INSERT INTO a VALUES (2); | ||
Latest revision as of 10:06, 17 July 2012
Rename column
schema:scott
DROP TABLE a
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);
ALTER TABLE a CHANGE x y INTEGER;
SELECT * FROM a
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);
ALTER TABLE a RENAME COLUMN x TO y;
SELECT * FROM a
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);
ALTER TABLE a RENAME COLUMN x TO y;
SELECT * FROM a
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);
ALTER TABLE a RENAME COLUMN x TO y;
USE scott;
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);
sp_rename 'a.x', 'y', 'COLUMN';
SELECT * FROM a;
Not possible
CREATE TABLE a(x INTEGER);
INSERT INTO a VALUES (2);
ALTER TABLE a RENAME COLUMN x TO y;
SELECT * FROM a