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

5 votes105 views1 answer
Oracle sysdate
SQL
2 votes123 views4 answers
Sql query interview questions
SQL
3 votes141 views1 answer
How to get yesterday date in sql
SQL
0 vote106 views1 answer
How to use group_concat in sql server
SQL
3 votes66 views1 answer
System.debug apex
SQL
0 vote119 views1 answer
Flexible search query delete table
SQL
23 votes102 views6 answers
How to create table in sql
SQL
12 votes110 views4 answers
Import mysql database command line linux
SQL
0 vote113 views2 answers
How to update the multiple rows in sql
SQL
7 votes121 views4 answers
Mysql delete older duplicates
SQL