DATABASE

TD SQL；

HELP DATABASE TD01;

Table/View/Macro name Kind Comment
------------------------------ ---- ---------------------------------------
EMPLOYEE T ?

 

// 显示对象信息

显示建表语句！

---------------------------------------------------------------------------
CREATE SET TABLE TD01.employee ,FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
EmployeeNo INTEGER,
FirstName VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
LastName VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
DOB DATE FORMAT 'YYYY-MM-DD',
JoinedDate DATE FORMAT 'YYYY-MM-DD',
DepartmentNo BYTEINT)
UNIQUE PRIMARY INDEX ( EmployeeNo );

show table employee;