02-sqllite3 alter: Add, modify, or delete columns in an existing table

The ALTER TABLE statement is used to add, modify, or delete a column's original table in an existing table:

first, Alter adds a new column to the table

syntax:ALTER TABLE table_name ADD COLUMN_NAME datatype

Note : Alter in SQLITE3 does not support the operation of deleting columns

Note : Alter cannot change the name, data type, qualifier, etc. of a field that already existsin Sqlite3

second, alter modify table name

syntax:alter table name rename to new table name ;

02-sqllite3 alter: Add, modify, or delete columns in an existing table