Sqlite rename table

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 vote134 views1 answer
Truncate table sql server foreign key
SQL
-1 vote143 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
7 votes148 views1 answer
Mysql remote connection command line
SQL
1 vote163 views1 answer
Apex select list ORA-20999
SQL
1 vote232 views1 answer
Alter constraint postgres
SQL
24 votes145 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote152 views1 answer
Get date from timestamp in mysql
SQL
22 votes251 views4 answers
Tsql rename table
SQL
0 vote132 views1 answer
First Step in installing SQL workbench
SQL
13 votes134 views6 answers
Mysql update from select
SQL