CREATE/REPLACE ORDERING Syntax | Teradata Vantage - 17.10 - CREATE ORDERING and REPLACE ORDERING Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
{ CREATE | REPLACE } ORDERING FOR [ SYSUDTLIB. ] UDT_name
  ORDER FULL BY MAP WITH { method_specification | function_specification } [;]
method_specification
{ SPECIFIC METHOD [ SYSUDTLIB. ] specific_method_name |
  [ INSTANCE ] METHOD [ SYSUDTLIB. ] method_name
    ( [ { data_type | [ SYSUDTLIB. ] UDT_name } [,...] ] )  
} FOR UDT_name
function_specification
{ SPECIFIC FUNCTION [ SYSUDTLIB. ] specific_function_name |	
  FUNCTION [ SYSUDTLIB. ] function_name
    ( [ { data_type | [ SYSUDTLIB. ] UDT_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 ]) |

  { XML | XMLTYPE } |

  JSON [ ( integer ) ] [ CHARACTER SET { UNICODE | LATIN } ] |

  [SYSUDTLIB.] { UDT_name | ST_Geometry | MBR | ARRAY_name | VARRAY_name }
}