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

3 votes190 views1 answer
Dbms_scheduler drop_job
SQL
1 vote184 views2 answers
Grab part of a string sql
SQL
-1 vote194 views1 answer
Ssql to lowercqse
SQL
5 votes238 views1 answer
Oracle source query
SQL
1 vote179 views1 answer
List all triggers in SQL Server
SQL
0 vote186 views1 answer
Except in sql
SQL
1 vote203 views1 answer
Vagrant mysql downgrade version
SQL
0 vote170 views1 answer
Get created time of database psql 8
SQL
0 vote183 views2 answers
Create-toys-table-with-toy_name-column
SQL
8 votes183 views3 answers
Oracle auto_increment
SQL