sqliteHow do I rename a table in SQLite?
Renaming a table in SQLite is easy and can be done with the ALTER TABLE
command. The basic syntax for renaming a table is:
ALTER TABLE old_table_name
RENAME TO new_table_name;
In the above example, old_table_name
is the name of the table to be renamed, and new_table_name
is the new name of the table.
For example, let's say we have a table called tbl_employees
and we want to rename it to tbl_staff
. We can do this with the following command:
ALTER TABLE tbl_employees
RENAME TO tbl_staff;
The output of this command will be:
Table tbl_employees renamed to tbl_staff
List of code parts
ALTER TABLE
- The command used to rename a table in SQLiteold_table_name
- The name of the table to be renamedRENAME TO
- The keyword used to specify the new name of the tablenew_table_name
- The new name of the table
Relevant Links
More of Sqlite
- How to configure SQLite with XAMPP on Windows?
- How can I use SQLite with Xamarin Forms?
- How do I use SQLite with Visual Studio?
- How do I extract the year from a datetime value in SQLite?
- How do I use an SQLite UPDATE statement with a SELECT query?
- How do I use regular expressions to query a SQLite database?
- How do I use the SQLite ZIP VFS to compress a database?
- How can I use SQLite with Zabbix?
- How can I query a SQLite database for records from yesterday's date?
- How do I use the SQLite YEAR function?
See more codes...