Rename column

Rename column

schema:scott

DROP TABLE a

CREATE TABLE t_test
 (a INTEGER NOT NULL PRIMARY KEY
 ,b VARCHAR(10)
 )

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

It is not possible to remove a column in SQLite.

The stored procedure sp_rename will do this.

Thanks to Mike Wasson, Orlando, Florida

ALTER TABLE

CREATE and DROP Operations

CREATE a new table

DROP a table

Composite primary key

CREATE a foreign key

CREATE a VIEW

Autonumber fields

ALTER TABLE ... ADD COLUMN

ALTER TABLE ... DROP COLUMN

ALTER TABLE ... ADD constraint

CREATE TABLE problems: Invalid column name.

CREATE TABLE problems: Insufficient privileges.

CREATE TABLE problems: Table already exists.

DROP TABLE problems: Foreign key references.

CREATE TABLE problems: Foreign key references.

Rename column