Sqlite rename column

-- Oracle, MySQL 8+
ALTER TABLE table_name RENAME COLUMN current_name TO new_name;
-- MySQL < 8:
ALTER TABLE table_name CHANGE current_name new_name datatype(length);
-- SQL Server:
EXEC SP_RENAME 'table_name.current_name' , 'new_name', 'COLUMN'

Sqlite rename table

ALTER TABLE my_table TO new_name;

Source: sqlitetutorial.net

Similar codes

0 vote136 views1 answer
Select year from dual oracle
SQL
13 votes122 views6 answers
Current date sql
SQL
0 vote121 views1 answer
Sql clear table
SQL
0 vote136 views1 answer
Manage Database in MySQL
SQL
5 votes136 views3 answers
Truncate function in sql oracle
SQL
5 votes120 views4 answers
Rollback to in sql
SQL
0 vote88 views2 answers
Sql query unique
SQL
0 vote137 views1 answer
Oracle to_number
SQL
21 votes134 views3 answers
Sql server search column name in all tables
SQL
0 vote162 views1 answer
Sql get latest of 2 datetimes
SQL