Skip to content
Related Articles

Related Articles

Improve Article

Python SQLite – Create Table

  • Last Updated : 21 Apr, 2021

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

In SQLite database we use the following syntax to create a table:

CREATE TABLE database_name.table_name(

                                       column1 datatype PRIMARY KEY(one or more columns),

                                       column2 datatype,



                                       column3 datatype,

                                       …..

                                       columnN datatype

);

Now we will create a table using Python:

Approach:

Import the required module

  • Establish the connection or create a connection object with the database using the connect() function of the sqlite3 module.
  • Create a Cursor object by calling the cursor() method of the Connection object.
  • Form table using the CREATE TABLE statement with the execute() method of the Cursor class.

Implementation:

Python3




import sqlite3
  
# Connecting to sqlite
# connection object
connection_obj = sqlite3.connect('geek.db')
  
# cursor object
cursor_obj = connection_obj.cursor()
  
# Drop the GEEK table if already exists.
cursor_obj.execute("DROP TABLE IF EXISTS GEEK")
  
# Creating table
table = """ CREATE TABLE GEEK (
            Email VARCHAR(255) NOT NULL,
            First_Name CHAR(25) NOT NULL,
            Last_Name CHAR(25),
            Score INT
        ); """
  
cursor_obj.execute(table)
  
print("Table is Ready")
  
# Close the coonection
connection_obj.close()

Output:

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course

My Personal Notes arrow_drop_up
Recommended Articles
Page :