CREATE/REPLACE ORDERING Syntax | Teradata Database - CREATE ORDERING and REPLACE ORDERING Syntax - Teradata Database

{ 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 }
}