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 vote379 views1 answer
Nvl postgres
SQL
-1 vote371 views1 answer
Minus vs except in sql
SQL
0 vote351 views1 answer
Mysql count unique in group statement
SQL
0 vote391 views1 answer
Add new column in sql with foreign key
SQL
-1 vote355 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote334 views1 answer
Mysql update privileges
SQL
0 vote347 views1 answer
Copy Table from SQL to CSV
SQL
1 vote349 views1 answer
Python clean sql string
SQL
4 votes389 views1 answer
Mysql query first character
SQL
0 vote323 views1 answer
Check if a word appears at the end sql query
SQL