Bài 6: Tạo và xóa bảng trong SQLite - Học SQLite cơ bản

1. Tạo bảng

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

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

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

sqlite> .tablesCOMPANY     DEPARTMENT

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

2. Xóa bảng

DROP TABLE database_name.table_name;

sqlite> .tablesCOMPANY       test.COMPANY

sqlite> DROP TABLE COMPANY;sqlite>

sqlite> .tablessqlite>