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

-1 vote285 views1 answer
Sql select data from one database and insert into a different database
SQL
1 vote264 views1 answer
How to truncate a table in databse
SQL
0 vote254 views1 answer
How to get all values in a table mysql in c#
SQL
-1 vote270 views1 answer
Mysql #1064 error
SQL
1 vote230 views1 answer
Mssql string length
SQL
0 vote281 views1 answer
Creating a simple notify in postgresql
SQL
0 vote239 views1 answer
Update row in sqlite python
SQL
39 votes338 views4 answers
Select duplicates in sql
SQL
0 vote311 views1 answer
How to get button for every record from mysql
SQL
0 vote307 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL