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

6 votes345 views1 answer
Postgresql get year
SQL
0 vote354 views1 answer
Placements hackerrank solution
SQL
0 vote351 views1 answer
Install mysql 8 linux
SQL
12 votes393 views1 answer
Run mysql instance in docker
SQL
2 votes405 views1 answer
Oracle run_duration to number
SQL
10 votes325 views1 answer
Oracle dependency
SQL
0 vote364 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote400 views1 answer
Sql constarint
SQL
0 vote356 views1 answer
Alter owner in PostgreSQL
SQL
0 vote382 views1 answer
Postrgres trunc
SQL