DROP DATATYPE statement

Use this statement to remove a datatype from the database.

Syntax
DROP DATATYPE datatype-name
Remarks

Use the IF EXISTS clause if you do not want an error returned when the DROP statement attempts to remove a database object that does not exist.

It is recommended that you use DROP DOMAIN rather than DROP DATATYPE, as DROP DOMAIN is the syntax used in the ANSI/ISO SQL3 draft. You cannot drop system-defined data types (such as MONEY or UNIQUEIDENTIFIERSTR) from a database.

Permissions

Any user who owns the object, or has DBA authority, can execute the DROP DATATYPE statement.

Side effects

Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.

See also
Standards and compatibility
  • SQL/2003   Core feature.

Example

Drop MyDatatype from the database. If the datatype does not exist, an error is returned.

DROP DATATYPE MyDatatype;