<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='EMP'>
/****************************************************************************/
/* EMP ( 従業員ﾏｽﾀ )                                                        */
/*                                                                          */
/* Created : 2022/11/10 17:41:42                                            */
/****************************************************************************/
<EXEC_SQL exists="0">
SELECT COUNT(*) FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG=0 and RDB$RELATION_TYPE=0 and RDB$RELATION_NAME=UPPER('EMP');
CREATE TABLE EMP (
   EMPNO    INTEGER             DEFAULT 0   NOT NULL                
 , ENAME    VARCHAR ( 10 )                                          
 , JOB      VARCHAR (  9 )                                          
 , MGR      INTEGER                                                 
 , HIREDATE VARCHAR (  8 )                                          
 , SAL      INTEGER                                                 
 , COMM     INTEGER                                                 
 , DEPTNO   INTEGER             DEFAULT 0   NOT NULL                
);
</EXEC_SQL>
</ROWSET>
