例: テーブルに対するHELP COLUMN - Teradata Database - Teradata Vantage NewSQL Engine - 例: テーブルに対するHELP COLUMN、HELP COLUMN構文の文。

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

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
2019年3月
Language
日本語
Last Update
2019-10-29
dita:mapPath
ja-JP/wkf1512081455740.ditamap
dita:ditavalPath
ja-JP/wkf1512081455740.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage

KanjiEBCDICユーザーが、4つの文字データ型を使用するテーブルを作成します。

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

このHELP COLUMNリクエストは、すべての列の情報を表示します。

     HELP COLUMN table_1.*;

SIDETITLESオプションとFOLDLINEオプションを使用してフォーマットされた、省略形のBTEQ出力を次に示します。

Column Name clatin
Type CF
Format X(5)
Max Length 5
Title ?
Column Constraint ?
Char Type 1
IdCol Type ?
UDT Name ?
Temporal Column ?
Current ValidTime Unique ?
Sequenced ValidTime Unique ?
Nonsequenced ValidTime Unique ?
Current TransactionTime Unique ?
Partitioning Column N
Column Partition Number 0
Column Partition Format NA
Column Partition AC NA
Security Constraint N
Derived_UDT ?
Derived_UDTFieldID ?
Column Name cgraphic
Type CF
Format X(5)
Max Length 10
Title ?
Column Constraint ?
Char Type 4
IdCol Type ?
Temporal Column N
Current ValidTime Unique ?
Sequenced ValidTime Unique ?
NonSequenced ValidTime Unique ?
Current TransactionTime Unique ?
Partitioning Column N
Column Partition Number 0
Column Partition Format NA
Column Partition AC NA
ConstraintID ?
Derived_UDT ?
Derived_UDTFieldID ?
Column Name csjis
Type CF
Format X(5)
Max Length 5
Title ?
Column Constraint ?
Char Type 3
IdCol Type ?
UDT Name ?
Temporal Column N
Current ValidTime Unique ?
Sequenced ValidTime Unique ?
NonSequenced ValidTime Unique ?
Current TransactionTime Unique ?
Partitioning Column N
Column Partition Number 0
Column Partition Format NA
Column Partition AC NA
Security Constraint ?
Derived_UDT ?
Derived_UDTFieldID ?
Column Name cunicode
Type CF
Format X(5)
Max Length 10
Title ?
Column Constraint ?
Char Type 2
IdCol Type ?
UDT Name ?
Temporal Column N
Current ValidTime Unique ?
Sequenced ValidTime Unique ?
NonSequenced ValidTime Unique ?
Current TransactionTime Unique ?
Partitioning Column N
Column Partition Number 0
Column Partition Format NA
Column Partition AC NA
Security Constraint N
Derived_UDT ?
Derived_UDTFieldID ?