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 vote199 views2 answers
How to check if a column exists in a SQL Server table?
SQL
-2 votes296 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote215 views1 answer
How to to get time in sql
SQL
0 vote3.7K views1 answer
PSQL use LIKE with timestamps
SQL
1 vote198 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote208 views1 answer
Copied text from internet not inserting in mysql
SQL
11 votes237 views2 answers
Sql rank
SQL
0 vote213 views1 answer
Mysql error 1251
SQL
0 vote212 views2 answers
Sql stored procedure for access frontend
SQL
1 vote187 views1 answer
Mysql random limit 1
SQL