SQLite Learning Note 4: Creating and Deleting tables

Before doing so much not just for the data to get a few tables, then see how to create a new table.

A new table

The basic syntax is as follows:

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

where database_name is your database name, table_name of course is the table name, ColumnN is listed, Primary_key is the primary key, datatype is the data type of this column.

For example, create a new user table:

CREATE TABLE USER (   ID int PRIMARY KEY not     null,   NAME           TEXT not    null, age INT not     null,< C8/>address        CHAR (50));

# "Not NULL" specifies that the current column cannot be empty

After you are done, you can view the newly created table with the following command:

. Tables

To view the detailed structure of a table, use the command:

. Schema

Two Delete table

Use the command:

DROP TABLE Database_name.table_name;