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

3 votes336 views1 answer
Créer une table sql
SQL
1 vote374 views1 answer
Oracle see column type
SQL
11 votes310 views2 answers
Sql between date range
SQL
1 vote315 views1 answer
Limit offset order by mysql
SQL
7 votes380 views1 answer
Buy forge mods server hosting
SQL
1 vote319 views6 answers
In sql
SQL
1 vote320 views1 answer
Loading local data is disabled mysql
SQL
0 vote306 views2 answers
Avg() sql
SQL
1 vote335 views1 answer
Duplicating a MySQL table with all the data Command
SQL
4 votes314 views1 answer
Postgresql show current database
SQL