To define the structure, we CREATE TABLE (also ALTER TABLE and DROP TABLE) CREATE TABLE base-table-name (col-name data type [NOT NULL [WITH DEFAULT]] [,col-name data type [NOT NULL [WITH DEFAULT]] ...,[PRIMARY KEY (col-name, [,col-name],...)], [FOREIGN KEY (col-name,[,col-name]...) REFERENCES (other-base-table-name)]) Some examples are: CREATE TABLE student (stuid CHAR(9) NOT NULL, stuname CHAR(20) NOT NULL, major CHAR(20), credits SMALLINT, PRIMARY KEY (stuid)); Which creates the student table with fields student id, student Name, major and credits.