1. 查看建表语句

　show table EMPLOYEE;

1.建表

CREATE SET TABLE EMPLOYEE,FALLBACK (

EmployeeNo INTEGER,

FirstName VARCHAR(30),

LastName VARCHAR(30),

DOB DATE FORMAT 'YYYY-MM-DD',

JoinedDate DATE FORMAT 'YYYY-MM-DD',

DepartmentNo BYTEINT

)

UNIQUE PRIMARY INDEX ( EmployeeNo );