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 vote126 views2 answers
Postgresql variable in query
SQL
0 vote120 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
11 votes120 views2 answers
Mysql set safe mode off
SQL
0 vote113 views1 answer
Recover deleted data from mysql database
SQL
0 vote152 views2 answers
Sql unique
SQL
0 vote117 views1 answer
T-sql update table variale
SQL
0 vote117 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote127 views1 answer
Automated psql csv export script on windows
SQL
0 vote70 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote85 views2 answers
Delete the last item in a table sql
SQL