<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF42'>
/****************************************************************************/
/* GF42 ( 郵便番号定義 )                                                    */
/* Created : 2021/06/29 14:03:37                                            */
/****************************************************************************/

<EXEC_SQL>
ALTER TABLE GF42 DROP CONSTRAINT GF42_LUQ
</EXEC_SQL>
<EXEC_SQL>
ALTER TABLE GF42 ADD CONSTRAINT GF42_LUQ UNIQUE( POSTCODE,PREF_KANA,CITY_KANA,TOWN_KANA )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K )

</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF42_SA
</EXEC_SQL>
<EXEC_SQL>
CREATE INDEX GF42_SA ON GF42( JIGYO_KANA )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )

</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF42_SB
</EXEC_SQL>
<EXEC_SQL>
CREATE INDEX GF42_SB ON GF42( CITY_KANA,JISCODE )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )

</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF42_SC
</EXEC_SQL>
<EXEC_SQL>
CREATE INDEX GF42_SC ON GF42( TOWN_KANA )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )

</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF42_SD
</EXEC_SQL>
<EXEC_SQL>
CREATE INDEX GF42_SD ON GF42( JIGYO_KANJI )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )

</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF42_SE
</EXEC_SQL>
<EXEC_SQL>
CREATE INDEX GF42_SE ON GF42( CITY_KANJI )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )

</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF42_SF
</EXEC_SQL>
<EXEC_SQL>
CREATE INDEX GF42_SF ON GF42( TOWN_KANJI )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )

</EXEC_SQL>
</ROWSET>
