ALTER TYPE

Alter a user-defined type.

 

 

alter_type.png

 

where alter-action is:

alter_action.png

 

where method is:

method.png

 

and where specific-method is:

specific_method.png

 

and method-specification is:

method_specification.png

 

and routine-attribute is:

routine_attribute.png

 

Usage

Embedded, Interactive, Module, ODBC, JDBC

Description

The ALTER TYPE statement is used to add method specifications to a type, or to drop method specifications from a type.

It is only the creator of a type that can alter it.

For information on method-specification, please see CREATE TYPE.

Restrictions

The restrictions for CREATE TYPE applies to ALTER TYPE also. (See CREATE TYPE.)

Standard Compliance

Standard

Compliance

Comments

SQL-2016

Features outside core

 

Alter a user-defined type.