SHOW object構文 - 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
SHOW {
  [ IN XML ] HASH INDEX [ database_name. | user_name. ] hash_index_name |

  [ IN XML ] JOIN INDEX [ database_name. | user_name. ] join_index_name |

  MACRO [ database_name. | user_name. ] macro_name |

  [ TEMPORARY ] TABLE [ database_name. | user_name. ] table_name |

  ERROR TABLE FOR [ database_name. | user_name. ] data_table_name |

  [ IN XML ] TABLE [ database_name. | user_name. ] error_table_name |

  TRIGGER [ database_name. | user_name. ] trigger_name |

  [ IN XML ] VIEW [ database_name. | user_name. ] view_name |

  PROCEDURE [ database_name. | user_name. ] procedure_name |

  SPECIFIC FUNCTION [ database_name. | user_name. ] specific_function_name |

  FUNCTION [ database_name. | user_name. ] function_name
    [ ( { data_type | UDT_name }[,...] ) ] |

  SPECIFIC METHOD [SYSUDTLIB.] specific_method_name |

  method |

  CAST [SYSUDTLIB.] UDT_name |

  TYPE [SYSUDTLIB.] { UDT_name | ARRAY_name | VARRAY_name } |

  storage_format SCHEMA [SYSUDTLIB.] schema_name |

  FILE [ uif_database_name. | uif_user_name. ] uif_name |

  CONSTRAINT constraint_name |

  AUTHORIZATION authorization_name |

  GLOP SET GLOP_set_name
}
data_type
{ INTEGER | SMALLINT | BIGINT | BYTEINT | DATE |

  { TIME | TIMESTAMP } [ (fractional_seconds_precision) ] [WITH TIME ZONE] |

  INTERVAL YEAR [(precision)] [TO MONTH] |

  INTERVAL MONTH [(precision)] |

  INTERVAL DAY [(precision)]
    [TO { HOUR | MINUTE | SECOND [(fractional_seconds_precision)] }] |

  INTERVAL HOUR [(precision)]
    [TO { MINUTE | SECOND [(fractional_seconds_precision)] }] |

  INTERVAL MINUTE [(precision)] [TO SECOND [(fractional_seconds_precision)]] |

  INTERVAL SECOND [ ( precision [, fractional_seconds_precision ] ) |

  PERIOD (DATE) |

  PERIOD ( { TIME | TIMESTAMP } [(precision)] [WITH TIME ZONE] ) |

  REAL |

  DOUBLE PRECISION |

  FLOAT [ (integer) ] |

  NUMBER [ ( { integer | *} [, integer ] ) ] |

  { DECIMAL | NUMERIC } [ ( integer [, integer ] ) ] |

  { CHAR | BYTE | GRAPHIC } [ (integer) ] |

  { VARCHAR | CHAR VARYING | VARBYTE | VARGRAPHIC } (integer) |

  LONG VARCHAR |

  LONG VARGRAPHIC |

  { BINARY LARGE OBJECT | BLOB | CHARACTER LARGE OBJECT | CLOB }
    ( integer [ G | K | M ] ) |

  [SYSUDTLIB.] { XML | XMLTYPE } [ ( integer [ G | K | M ] ) ]
    [ INLINE LENGTH integer ] |

  [SYSUDTLIB.] JSON [ ( integer [ K | M ] ) ] [ INLINE LENGTH integer ]
    [ CHARACTER SET { UNICODE | LATIN } | STORAGE FORMAT { BSON | UBJSON } ] |

  [SYSUDTLIB.] ST_GEOMETRY [ (integer [ K | M ]) ] [ INLINE LENGTH integer ] |

  [SYSUDTLIB.] DATASET [ (integer [ K | M ]) ] [ INLINE LENGTH integer ]
    storage_format |

  [SYSUDTLIB.] { UDT_name | MBR | ARRAY_name | VARRAY_name }
}
method
[ INSTANCE | CONSTRUCTOR ] METHOD [SYSUDTLIB.] method_name
  [ ( { data_type | UDT_name }[,...] ) ]
  FOR UDT_name
storage_format
STORAGE FORMAT { Avro | CSV [ CHARACTER SET { UNICODE | LATIN } ] }
  [ WITH SCHEMA [ database. ] schema_name ]