Materialize Documentation
Join the Community github/materialize

DROP TYPE

New in v0.7.1.

DROP TYPE removes a custom data type. You cannot use it on default data types.

Syntax

DROP TYPE IF EXISTS data_type_name RESTRICT CASCADE
Field Use
IF EXISTS Do not return an error if the named type doesn’t exist.
data_type_name The name of the type to remove.
CASCADE Remove the type and its dependent objects, such as tables or other types.
RESTRICT Don’t remove the type if any objects depend on it. (Default.)

Examples

Remove a type with no dependent objects

CREATE TYPE int4_map AS MAP (key_type=text, value_type=int4);

SHOW TYPES;
    name
--------------
  int4_map
(1 row)
DROP TYPE int4_map;

SHOW TYPES;
  name
--------------
(0 rows)

Remove a type with dependent objects

By default, DROP TYPE will not remove a type with dependent objects. The CASCADE switch will remove both the specified type and all its dependent objects.

In the example below, the CASCADE switch removes int4_list, int4_list_list (which depends on int4_list), and the table t, which has a column of data type int4_list.

CREATE TYPE int4_list AS LIST (element_type = int4);

CREATE TYPE int4_list_list AS LIST (element_type = int4_list);

CREATE TABLE t (a int4_list);

SHOW TYPES;
      name
----------------
 int4_list
 int4_list_list
(2 rows)
DROP TYPE int4_list CASCADE;

SHOW TYPES;

SELECT * FROM t;
 name
------
(0 rows)
ERROR:  unknown catalog item 't'

Remove a type only if it has no dependent objects

You can use either of the following commands:

Do not issue an error if attempting to remove a nonexistent type

DROP TYPE IF EXISTS int4_list;
Did this info help?
Yes No