Javatpoint Logo
Javatpoint Logo

SQLite Create Table

In SQLite, CREATE TABLE statement is used to create a new table. While creating the table, we name that table and define its column and data types of each column.


Let's take an example to create table in SQLite database:

SQLite Create table 1

Use the SQLite ".tables" command to see if your table has been created successfully.


SQLite Create table 2

Let's create another table DEPERTMENT for future operations.

Now, we have two tables "DEPARTMENT" and "STUDENT".

SQLite Create table 3

Now check the created tables:

SQLite Create table 4
Next TopicSQLite Drop Table

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA