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

1 vote166 views1 answer
Update and replace mysql
SQL
0 vote184 views1 answer
Mysql get only the field names in a table
SQL
4 votes179 views1 answer
Describe table mysql
SQL
3 votes169 views1 answer
Mysql load sql from file
SQL
0 vote151 views1 answer
Postgresql subquery
SQL
0 vote171 views1 answer
Coalesce for comma separated in sql server
SQL
1 vote187 views1 answer
Replace all numbers in mysql
SQL
0 vote133 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote169 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
5 votes161 views2 answers
Sql conn
SQL