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.

Syntax:

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.

.tables

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




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA