Changing the name of the table

The syntax of ALTER TABLE to change the name of the table in SQLite is given below:

ALTER TABLE table_name RENAME TO newTableName;

We will use the same GEEK table that we created above:

Python3

import sqlite3
 
# Connecting to sqlite
connection_obj = sqlite3.connect('geek.db')
 
# cursor object
cursor_obj = connection_obj.cursor()
 
# select from sqlite_master
cursor_obj.execute("SELECT * FROM sqlite_master")
 
table = cursor_obj.fetchall()
print("Before changing the name of Table")
print("The name of the table:", table[0][2])
 
# Rename the SQLite Table
renameTable = "ALTER TABLE GEEK RENAME TO GFG"
cursor_obj.execute(renameTable)
 
 
# select from sqlite_master
cursor_obj.execute("SELECT * FROM sqlite_master")
 
table = cursor_obj.fetchall()
 
print("After changing the name of Table")
print("The name of the table:", table[0][2])
 
connection_obj.commit()
 
connection_obj.close()

Output:

How to Alter a SQLite Table using Python ?

In this article, we will discuss how can we alter tables in the SQLite database from a Python program using the sqlite3 module.

We can do this by using ALTER statement. It allows to:

Add one or more column to the table

Tags:

#Python-SQLite #Python #python

Change the name of the table.

Changing the name of the table

Python3

How to Alter a SQLite Table using Python ?

Similar Reads