<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF42'>
/****************************************************************************/
/* GF42 ( 郵便番号定義 )                                                    */
/*                                                                          */
/* Created : 2022/11/10 17:41:31                                            */
/****************************************************************************/
<EXEC_SQL exists="0">
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME=LOWER('GF42');
CREATE TABLE GF42 (
   jiscode          varchar (   5 )         not null                
 , postcode_short   varchar (   5 )                                 
 , postcode         varchar (   7 )         not null                
 , jigyo_kana       varchar ( 300 )                                 
 , pref_kana        varchar (  30 )                                 
 , city_kana        varchar ( 100 )                                 
 , town_kana        varchar ( 300 )                                 
 , jigyo_kanji      varchar ( 300 )                                 
 , pref_kanji       varchar (  12 )                                 
 , city_kanji       varchar (  36 )                                 
 , town_kanji       varchar ( 200 )                                 
 , block_kanji      varchar ( 200 )                                 
 , code_shu         varchar (   1 )                                 
);
</EXEC_SQL>
</ROWSET>
