Example: SHOW TABLE for a User with a Default Character Type of Latin - Teradata Vantage - Analytics Database

This CREATE TABLE request creates the following table for a user whose default character type is Latin.

     CREATE TABLE kanji_user.table_1,
       NO FALLBACK,
       NO BEFORE JOURNAL,
       NO AFTER JOURNAL
       (
        clatin     CHARACTER(5),
        ckanji1    CHARACTER(5) CHARACTER SET UNICODE,
        cgraphic   CHARACTER(5) CHARACTER SET GRAPHIC,
        ckanjisjis CHARACTER(5) CHARACTER SET KANJISJIS,
        cunicode   CHARACTER(5))
     PRIMARY INDEX (clatin);

A SHOW TABLE request for this table returns the following CREATE TABLE SQL text, as expected.

     CREATE TABLE kanji_user.table_1,
       NO FALLBACK,
       NO BEFORE JOURNAL,
       NO AFTER JOURNAL (
        clatin CHARACTER(5) CHARACTER SET LATIN,
        ckanji1 CHARACTER(5) CHARACTER SET UNICODE,
        cgraphic CHARACTER(5) CHARACTER SET GRAPHIC,
        ckanjisjis CHARACTER(5) CHARACTER SET KANJISJIS,
        cunicode CHARACTER(5) CHARACTER SET LATIN)
     PRIMARY INDEX ( clatin );