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 the SQLite ZIP VFS to compress a database?
- How do I extract the year from a datetime value in SQLite?
- How do I use SQLite UNION to combine multiple SELECT queries?
- How do I use SQLite with Zephyr?
- How do I import data from a SQLite zip file?
- How do I use the SQLite zfill function?
- How do I call sqlitepcl.raw.setprovider() when using SQLite?
- How do I use variables in a SQLite database?
- How do I use regular expressions to query a SQLite database?
- How do I create a database using SQLite?
See more codes...