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

1 vote187 views1 answer
Multiple count in sql
SQL
4 votes191 views5 answers
Primary key
SQL
4 votes179 views2 answers
How to delete row in sql
SQL
0 vote206 views1 answer
How do I insert a blob in SQL?
SQL
0 vote212 views1 answer
Test sql query
SQL
1 vote196 views2 answers
Mysql switch case
SQL
3 votes222 views1 answer
Unsigned int in mysql
SQL
5 votes195 views2 answers
Oracle rename table
SQL
3 votes186 views1 answer
Fk in insert mysql
SQL
11 votes290 views5 answers
Update table from another table mysql
SQL