DROP TYPE()			 SQL Commands			   DROP TYPE()



NAME
       DROP TYPE - remove a data type


SYNOPSIS
       DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]


DESCRIPTION
       DROP  TYPE  removes a user-defined data type.  Only the owner of a type
       can remove it.

PARAMETERS
       IF EXISTS
	      Do not throw an error if the type does not exist.  A  notice  is
	      issued in this case.

       name   The  name  (optionally  schema-qualified)  of  the  data type to
	      remove.

       CASCADE
	      Automatically drop objects that depend on the type (such as  ta-
	      ble columns, functions, operators).

       RESTRICT
	      Refuse to drop the type if any objects depend on it. This is the
	      default.

EXAMPLES
       To remove the data type box:

       DROP TYPE box;


COMPATIBILITY
       This command is similar to the corresponding command in the  SQL  stan-
       dard, apart from the IF EXISTS option, which is a PostgreSQL extension.
       But note that the CREATE TYPE command and the data type extension mech-
       anisms in PostgreSQL differ from the SQL standard.

SEE ALSO
       CREATE TYPE [create_type(7)], ALTER TYPE [alter_type(l)]



SQL - Language Statements	  2010-03-12			   DROP TYPE()