SQLite to create a table

SQLite TheCREATE TABLE statement is used in any given database to create a new table.Creating a Basic Table, relates to the data type name tables, columns, and each column definitions.

grammar

The basic syntax of CREATE TABLE statement is as follows:

CREATE TABLE database_name.table_name(
   column1 datatype  PRIMARY KEY(one or more columns),
   column2 datatype,
   column3 datatype,
   .....
   columnN datatype,
);

CREATE TABLE tells the system to create a new database table keyword. CREATE TABLE statement is followed by a table name or unique identifier. You can also choose to specifydatabase_namewith thetable_name.

Examples

Here is an example, which creates a table COMPANY, ID as the primary key, NOT NULL constraint representation when creating a record in the table, these fields can not be NULL:

sqlite> CREATE TABLE COMPANY (
   ID INT PRIMARY KEY NOT NULL,
   NAME TEXT NOT NULL,
   AGE INT NOT NULL,
   ADDRESS CHAR (50),
   SALARY REAL
);

Let's create a table, we will be in the next chapter exercises use:

sqlite> CREATE TABLE DEPARTMENT (
   ID INT PRIMARY KEY NOT NULL,
   DEPT CHAR (50) NOT NULL,
   EMP_ID INT NOT NULL
);

You can use the SQLIte command.tables command to verify that the table has been successfully created, the command lists all the additional database tables.

sqlite> .tables
COMPANY DEPARTMENT

Here, we can see that we just created two tables COMPANY, DEPARTMENT.

You can useSQLite .schema command to get complete information on the table, as follows:

sqlite>.schema COMPANY
CREATE TABLE COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL
);