データ定義の使用 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - データ タイプおよびリテラル

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/tpf1598412463935.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1143
Product Category
Software
Teradata Vantage

以下のCREATE TABLE文は、Teradata SQLのデータ定義句を使ってEmployeeテーブルの列を定義します。

CREATE TABLE Employee
 (EmpNo PRIMARY KEY SMALLINT FORMAT '9(5)'
   CHECK(EmpNo BETWEEN 1000 AND 32001),
  Name VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
  DeptNo SMALLINT FORMAT '999'
   CHECK (DeptNo BETWEEN 100 AND 900),
  JobTitle VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
 Salary DECIMAL(8,2) FORMAT 'ZZZ,ZZ9.99'
   CHECK (Salary BETWEEN 1.00 AND 999000.00),
  YrsExp BYTEINT FORMAT 'Z9'
   CHECK (YrsExp BETWEEN -99 AND 99),
  DOB DATE FORMAT ’MMMbDDbYYYY’ NOT NULL,
  Sex CHAR CHARACTER SET LATIN UPPERCASE NOT NULL,
  Race CHAR CHARACTER SET LATIN UPPERCASE,
  MStat CHAR CHARACTER SET LATIN UPPERCASE,
  EdLev BYTEINT FORMAT 'Z9'
   CHECK (EdLev BETWEEN 0 AND 2) NOT NULL,
  HCap BYTEINT FORMAT 'Z9'
   CHECK (HCap BETWEEN -99 AND 99)
INDEX (Name) ;

以下のSELECT文は、TeradataSQLのデータ定義句を使って、EmpNo列の見出しとSalary列の結果の形式を修正します。

SELECT EmpNo (TITLE 'Employee Number'),
  Salary (FORMAT 'GLLZ(I)D9(F)')
FROM Employee;