例: XML形式のSHOW TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
2021年1月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/ncd1596241368722.ditamap
dita:ditavalPath
ja-JP/ncd1596241368722.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage

テーブルは以下のように定義されます。

     CREATE MULTISET TABLE YourDB.orders ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
      o_orderkey INTEGER,
      o_date DATE FORMAT 'yyyy-mm-dd',
      o_status CHAR(1) CHARACTER SET LATIN CASESPECIFIC,
      o_custkey INTEGER,
      o_totalprice DECIMAL(13,2),
      o_orderpriority CHAR(21) CHARACTER SET LATIN CASESPECIFIC,
      o_clerk CHAR(16) CHARACTER SET LATIN CASESPECIFIC,
      o_shippriority INTEGER,
      o_comment VARCHAR(79) CHARACTER SET LATIN CASESPECIFIC)
UNIQUE PRIMARY INDEX ( o_orderkey );

SHOW IN XML TABLEリクエストで生成されたXML文書は、このテーブルを再作成するために必要なすべての情報を報告します。

     <?xml version="1.0" encoding="UTF-8" standalone="no" ?><TeradataDBObjectSet version="1.0" xmlns="http://schemas.teradata.com/dbobject" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.teradata.com/dbobject http://schemas.teradata.com/dbobject/DBObject.xsd"><Table afterJournal="No" baseClass="Table" beforeJournal="No" checkSumLevel="Default" dbName="YourDB" fallback="false" kind="Multiset" map="TD_MAP1" map_kind="contiguous" mergeBlockRatio="Default" name="orders" objId="0:3650" objVer="4" systemVersioned="false">
<ColumnList><Column name="o_orderkey" nullable="true" order="1"><DataType><Integer/></DataType></Column>
<Column format="yyyy-mm-dd" name="o_date" nullable="true" order="2"><DataType><Date/></DataType></Column>
<Column name="o_status" nullable="true" order="3"><DataType><Char casespecific="true" charset="LATIN" length="1" uppercase="false" varying="false"/></DataType></Column>
<Column name="o_custkey" nullable="true" order="4"><DataType><Intege
r/></DataType></Column>
<Column name="o_totalprice" nullable="true" order="5"><DataType><Decimal precision="13" scale="2"/></DataType></Column>
<Column name="o_orderpriority" nullable="true" order="6"><DataType><Char casespecific="true" charset="LATIN" length="21" uppercase="false" varying="false"/></DataType></Column><Column name="o_clerk" nullable="true" order="7"><DataType><Char casespecific="true" charset="LATIN" length="16" uppercase="false" varying="false"/></DataType></Column>
<Column name="o_shippriority" nullable="true" order="8"><DataType><Integer/></DataType></Column>
<Column name="o_comment" nullable="true" order="9"><DataType><Char casespecific="true" charset="LATIN" length="79" uppercase="false" varying="true"/></DataType></Column></ColumnList>
<Indexes><PrimaryIndex unique="true"><ColumnList><Column name="o_orderkey" order="1"/></ColumnList></PrimaryIndex></Indexes>
<SQLText><![CDATA[CREATE MULTISET TABLE YourDB.orders ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
      o_orderkey INTEGER,
      o_date DATE FORMAT 'yyyy-mm-dd',
      o_status CHAR(1) CHARACTER SET LATIN CASESPECIFIC,
      o_custkey INTEGER,
      o_totalprice DECIMAL(13,2),
      o_orderpriority CHAR(21) CHARACTER SET LATIN CASESPECIFIC,
      o_clerk CHAR(16) CHARACTER SET LATIN CASESPECIFIC,
      o_shippriority INTEGER,
      o_comment VARCHAR(79) CHARACTER SET LATIN CASESPECIFIC)
UNIQUE PRIMARY INDEX ( o_orderkey )]]></SQLText></Table>
<Environment><Server dbRelease="16.10" dbVersion="16.10" hostName="localhost"/><User userId="00000704" userName="User"/><Session charset="UTF8" dateTime="2017-03-24T16:19:32"/></Environment>
</TeradataDBObjectSet>