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

-2 votes116 views1 answer
How to open database
SQL
0 vote147 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote123 views1 answer
Windows services sql
SQL
0 vote144 views1 answer
Oracle current date minus 1 day
SQL
1 vote149 views1 answer
How to select random rows from a table
SQL
3 votes110 views1 answer
Sql timestamp to date
SQL
0 vote130 views1 answer
Drop all procedures sql server
SQL
6 votes132 views3 answers
Sql select last id
SQL
1 vote211 views1 answer
Oracle current sequence value
SQL
0 vote127 views3 answers
Condition in count sql
SQL