<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='EMP'>
/****************************************************************************/
/* EMP ( 従業員ﾏｽﾀ )                                                        */
/*                                                                          */
/* Created : 2022/11/10 17:41:31                                            */
/****************************************************************************/
<EXEC_SQL exists="0">
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME=LOWER('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>
