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 vote186 views1 answer
Postgres add prefix to primary key
SQL
0 vote193 views4 answers
How to connect form to database
SQL
0 vote184 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote190 views1 answer
Get number of tables in database sql
SQL
0 vote197 views1 answer
Value of sold product using having and group by in sql
SQL
3 votes200 views1 answer
Oracle get trigger ddl
SQL
0 vote203 views2 answers
Which MySQL statement is used to delete data from a database
SQL
2 votes177 views1 answer
Oracle create directory
SQL
0 vote206 views2 answers
Greater than sql server
SQL
0 vote231 views1 answer
Stop and start mysql
SQL