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

5 votes265 views3 answers
Sql max value in column
SQL
1 vote257 views1 answer
Sql server insert into temp table
SQL
-1 vote301 views1 answer
Difference berween database and data base management system
SQL
0 vote248 views1 answer
Pl/sql loop example
SQL
1 vote248 views1 answer
SQL server query column yes or no
SQL
2 votes284 views2 answers
Create table mysql integer NOT null
SQL
0 vote229 views1 answer
Mysql create table columns with spaces
SQL
3 votes258 views1 answer
Sql is not like
SQL
8 votes252 views1 answer
Oracle add months to sysdate
SQL
0 vote254 views1 answer
Mysql add comment to column
SQL