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 vote219 views1 answer
Sql out file formate
SQL
0 vote204 views1 answer
Primary key multiple colums
SQL
0 vote255 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote209 views1 answer
Check constraint to check if date greater than todays date
SQL
11 votes241 views1 answer
Ddl view
SQL
0 vote198 views1 answer
Codeigniter 3 get best-selling products
SQL
-1 vote152 views3 answers
Ubuntu install mssql
SQL
0 vote197 views1 answer
Output table plsql
SQL
0 vote259 views1 answer
Sqlite trim
SQL
0 vote219 views1 answer
Postgresql create table with boolean column
SQL