Example: Show an Object File System Columnar Table - Teradata VantageCloud Lake

Show Table in SQL

SHOW TABLE pq_t1;

Result:

CREATE MULTISET TABLE D2.pq_t1 ,
     STORAGE = TD_OFSSTORAGE
     (
      c1 INTEGER,
      c2 INTEGER)
NO PRIMARY INDEX
PARTITION BY COLUMN;

Show Table in XML

SHOW IN XML TABLE pq_t1;

Result:

<?xml version="1.0" encoding="UTF-16" standalone="no" ?><TeradataDBObjectSe
t version="1.0" xmlns="http://schemas8956.example.com/dbobject" xmlns:xsi="ht
tp://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schema
s.teradata.com/dbobject http://schemas8956.example.com/dbobject/DBObject.xsd"
><Table baseClass="Table" dbName="D2" fallback="false" kind="Multiset" map_kind="contiguous" name="pq_t1" objId="1:7124" objVer="1" st
orage="TD_OFSSTORAGE" storage_kind="nos"><ColumnList>
<Column name="c1" nullable="
true" order="1">
<DataType><Integer/></DataType></Column><Column name="c2"
nullable="true" order="2"><DataType><Integer/></DataType></Column></Column
List><Indexes><NoPrimaryIndex><PartitioningList><ColumnPartitioning level="1"><ColumnGroup order="1"><ColumnList><Column name="c1" order="1"/></ColumnList></ColumnGroup><ColumnGroup
 order="2"><ColumnList><Column name="c2" order="1"/></
ColumnList></ColumnGroup></ColumnPartitioning></PartitioningList></NoPrima
ryIndex></Indexes><SQLText><![CDATA[CREATE MULTISET TABLE D2.pq_t1 ,NO FAL
LBACK 
     STORAGE = TD_OFSSTORAGE
     (
      c1 INTEGER,
      c2 INTEGER)
NO PRIMARY INDEX
PARTITION BY COLUMN]]></SQLText></Table><Environme
nt><Server dbRelease="20c.00.00.10" dbVersion="20c.00.00.10pq" hostName="T
DLabs"/><User userId="00000100" userName="DBC"/><Session charset="ASCII" d
ateTime="2022-06-09T04:04:02"/></Environment></TeradataDBObjectSet>