Eine Einführung in
SQL
Rename column
SQLite
Execute tidy up
code
silently
DROP TABLE a
Not possible
Specific to SQLite
It is not possible to remove a column in SQLite.
DB2
Execute tidy up
code
silently
DROP TABLE a
CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); ALTER TABLE a RENAME COLUMN x TO y; SELECT * FROM a
Specific to DB2
none
MS Access
Execute tidy up
code
silently
DROP TABLE a
CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); ALTER TABLE a RENAME COLUMN x TO y; SELECT * FROM a
Specific to MS Access
none
PostgreSQL
Execute tidy up
code
silently
DROP TABLE a
CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); ALTER TABLE a RENAME COLUMN x TO y; SELECT * FROM a
Specific to PostgreSQL
none
Oracle
Execute tidy up
code
silently
DROP TABLE a
CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); ALTER TABLE a RENAME COLUMN x TO y;
Specific to Oracle
ALTER TABLE
MS SQL Server
Execute tidy up
code
silently
DROP TABLE a
USE scott; CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); sp_rename 'a.x', 'y', 'COLUMN'; SELECT * FROM a;
Specific to MS SQL Server
The stored procedure
sp_rename
will do this.
Thanks to Mike Wasson, Orlando, Florida
MySQL
Execute tidy up
code
silently
DROP TABLE a
DROP TABLE a; CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); ALTER TABLE a CHANGE x y INTEGER; SELECT * FROM a
Specific to MySQL
none
Sybase
Execute tidy up
code
silently
DROP TABLE a
CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); ALTER TABLE a RENAME COLUMN x TO y; SELECT * FROM a
Specific to Sybase
none
Mimer SQL
Execute tidy up
code
silently
DROP TABLE a
CREATE TABLE a(x INTEGER); INSERT INTO a VALUES (2); ALTER TABLE a RENAME COLUMN x TO y; SELECT * FROM a
Specific to Mimer SQL
none