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 vote364 views1 answer
Create view in sql server that contain multiple select statements
SQL
3 votes284 views2 answers
Postgres alter table owner
SQL
1 vote283 views1 answer
Create new table from old table with data
SQL
0 vote271 views1 answer
Opensuse stop MySQL
SQL
0 vote274 views1 answer
Search In the Data using ObjectName
SQL
9 votes265 views2 answers
Oracle all tables in schema
SQL
0 vote262 views1 answer
Changer un mot de passe mysql
SQL
1 vote292 views3 answers
What is union in sql
SQL
0 vote306 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote288 views1 answer
How to search query in python3 sqlite3
SQL