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_staffList 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 do I use UUIDs in SQLite?
- How do I use SQLite with Visual Studio?
- How can I use an upsert statement to update data in a SQLite database?
- How do I install and use SQLite on Ubuntu?
- How can I use SQLite with Xamarin Forms?
- How do I use the SQLite sequence feature?
- How can I use SQLite with Xamarin Forms and C#?
- How do I use SQLite VACUUM to reclaim disk space?
- How do I use SQLite REPLACE to update existing records in a database?
- How do I use query parameters with SQLite?
See more codes...