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 vote276 views1 answer
C# sql transaction multiple connections
SQL
0 vote224 views1 answer
Double in sql server example
SQL
0 vote226 views1 answer
Mysqlimport
SQL
0 vote225 views1 answer
Oracle search in date columns
SQL
1 vote252 views1 answer
Mysql select all and rename one
SQL
0 vote223 views1 answer
Oracle right characters
SQL
0 vote222 views1 answer
Sqldf change user
SQL
0 vote234 views1 answer
Mysql date minus 1 day
SQL
0 vote249 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote229 views2 answers
2nd max salary query in sql
SQL