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 vote158 views1 answer
Sql get year from datetime field
SQL
1 vote150 views1 answer
Rename table column name in mysql
SQL
7 votes143 views2 answers
Html to react converter
SQL
7 votes136 views6 answers
Reset identity column in sql server
SQL
0 vote100 views1 answer
Update sql join multiple tables
SQL
6 votes143 views2 answers
Mysql convert timestamp to date
SQL
0 vote145 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote152 views1 answer
Remove mysql from centos 7
SQL
0 vote154 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
8 votes153 views3 answers
SQL column name
SQL