CREATE Table Common Commands

CREATE TABLE Students (stuid INTEGER not     null, Stuname char (+) not     null,sex     int not     null); CREATE TABLE Students (stuid INTEGER not     NULL, Stuname char (+) not     null,sex     int not     null,primary KEY ( STUID)); CREATE TABLE Students (stuid INTEGER not     null PRIMARY key,stuname char (a) not     null,sex     int not     null); CREATE TABLE score (Scoreid integer not NULL PRIMARY key,stuid     integer not null,kemuid     integer not Null,score
   float,foreign KEY SCORE_ID_FK (stuid) REFERENCES students (STUID), CONSTRAINT chk_score_zip CHECK (Score > 0)); show T Ables;insert into students values (1, ' Zhang San ', 1); SELECT * from Students;insert to Studentsselect * from Students;delete STUDENTS from studentswhere stuid = 1;drop TABLE STUDENTS; ALTER TABLE STUDENTS ADD CONSTRAINT PRIMARY KEY (STUID); ALTER TABLE STUDENTS ADD PRIMARY KEY (STUID);

CREATE Table Common Commands