SQLite’s ALTER TABLE The command does not modify an existing table by performing a complete dump and reloading of the data. You can use the
ALTER
TABLE
Statement to rename the table, using the
ALTER
TABLE
Statement can also add additional columns to an existing table.
In Used to rename an existing table ALTER TABLE The basic syntax is as follows: Used to add a new column to an existing table ALTER TABLE The basic syntax is as follows: Suppose our Now, let’s try using the Above. Now, the Note that the newly added columns are as follows
SQLite
Except for renaming tables and adding columns to existing tables, the
ALTER
TABLE
command does not support other operations. 1.37.1. Grammar ¶
ALTER TABLE database_name.table_name RENAME TO new_table_name;
ALTER TABLE database_name.table_name ADD COLUMN column_def...;
1.37.2. Example ¶
COMPANY
The table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
ALTER
TABLE
Statement to rename the table as follows:sqlite> ALTER TABLE COMPANY RENAME TO OLD_COMPANY;
SQLite
Statement will be renamed
COMPANY
The table is
OLD_COMPANY
. Now, let’s try to
OLD_COMPANY
Add a new column to the table, as follows:sqlite> ALTER TABLE OLD_COMPANY ADD COLUMN SEX char(1);
COMPANY
table has changed, using the
SELECT
The statement output is as follows:ID NAME AGE ADDRESS SALARY SEX
---------- ---------- ---------- ---------- ---------- ---
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
NULL
Value to fill in.