Eine Einführung in
SQL
Delete a column from a table
SQLite
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to SQLite
none
DB2
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to DB2
ALTER TABLE documentation.
DB2 seemingly does not permit this operation - any help would be appreciated.
MS Access
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to MS Access
none
PostgreSQL
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to PostgreSQL
ALTER TABLE
Oracle
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to Oracle
ALTER TABLE t DROP COLUMN c
MS SQL Server
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to MS SQL Server
none
MySQL
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to MySQL
none
Sybase
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP y
Specific to Sybase
Sybase doesn't like the COLUMN keyword.
Mimer SQL
This is in the SQL standard
ALTER TABLE
Execute tidy up
code
silently
DROP TABLE a
Execute set up
code
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y
Specific to Mimer SQL
none