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 vote303 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote307 views1 answer
Android sqlite add column if not exists
SQL
0 vote304 views4 answers
Change schema in sql server
SQL
0 vote325 views1 answer
Shrink database file in sql server
SQL
1 vote305 views1 answer
Oracle sql listagg
SQL
1 vote308 views1 answer
Postgres convert date to string
SQL
1 vote449 views3 answers
Uninstall postgresql mac
SQL
8 votes303 views1 answer
Show mysql user table
SQL
4 votes330 views1 answer
W3schools create table
SQL
23 votes325 views3 answers
Sql where contains part of string
SQL