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 vote107 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote128 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote126 views1 answer
Get the next column of a table in mysql
SQL
0 vote109 views1 answer
Mysql group rows with same value
SQL
1 vote67 views1 answer
Oracle boolean to varchar
SQL
0 vote118 views1 answer
Mysql root localhost run
SQL
1 vote117 views1 answer
Mysql get latest duplicate rows
SQL
0 vote118 views1 answer
Postgresql where clause not working
SQL
0 vote113 views1 answer
Where in clause tsql
SQL
1 vote109 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL