SQLite Create TableIn 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: ![]() Use the SQLite ".tables" command to see if your table has been created successfully. .tables ![]() Let's create another table DEPERTMENT for future operations. Now, we have two tables "DEPARTMENT" and "STUDENT". ![]() Now check the created tables: ![]()
Next TopicSQLite Drop Table
|