CREATE GLOBAL TEMPORARY TRACE TABLE Syntax | Teradata Vantage - CREATE GLOBAL TEMPORARY TRACE TABLE Syntax - Teradata Vantage - Analytics Database

CREATE GLOBAL TEMPORARY TRACE TABLE [ database_name. | user_name. ] table_name
  ( proc_ID BYTE(2) , sequence INTEGER [ column_specification [,...] ] )
  [ ON COMMIT { DELETE | PRESERVE } ROWS ] [;]

column_specification

column_name data_type data_type_attribute [...]

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 ] ) |

  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
}

data_type_attribute

{ NOT NULL |
  { UPPERCASE | UC } |
  [NOT] { CASESPECIFIC | CS } |
  FORMAT quotestring |
  TITLE quotestring |
  NAMED name |
  CHARACTER SET server_character_set
}