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;