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

103 votes424 views1 answer
Like sql
SQL
0 vote272 views1 answer
000webhost database values insert
SQL
0 vote267 views1 answer
Sparql if bound query
SQL
4 votes252 views2 answers
Sql table
SQL
20 votes248 views5 answers
Reset auto increment mysql
SQL
-1 vote222 views1 answer
Plsql while
SQL
0 vote268 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote223 views1 answer
Stored procedure return value
SQL
1 vote258 views1 answer
Psql autocomplete for mac brew install
SQL
4 votes246 views1 answer
Oracle table statistics last analyzed
SQL