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

15 votes121 views3 answers
Postgresql change column type
SQL
0 vote103 views1 answer
Suse start MySQL
SQL
0 vote124 views2 answers
Mysql dump database tables only
SQL
1 vote124 views1 answer
Create email address from first and last name in sql
SQL
3 votes115 views2 answers
Oracle drop column
SQL
0 vote131 views1 answer
Create synonym for dblink in oracle
SQL
0 vote123 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
4 votes126 views2 answers
Error loading MySQLdb module.
SQL
34 votes114 views6 answers
Install mysql client ubuntu
SQL
0 vote141 views1 answer
TSQL Find csv file in folder
SQL