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

10 votes226 views4 answers
SELECT FROM WHERE
SQL
1 vote229 views1 answer
Mysql check if string contains comma separated
SQL
1 vote174 views1 answer
Foreign key in oracle sql developer
SQL
42 votes222 views6 answers
Install beautifulsoup
SQL
4 votes208 views1 answer
Mysql copy table with new name
SQL
0 vote231 views1 answer
Check if a column is a primary key in sql server
SQL
2 votes203 views1 answer
Oracle drop table free up space
SQL
0 vote238 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote206 views1 answer
Sql server query database space available
SQL
0 vote221 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL