Yolinux.com

drop_type manpage

Search topic Section
Get manual page for the search topic
List all commands matching the search topic
List all topics in the manpage index

DROP TYPE()			 SQL Commands			   DROP TYPE()



NAME
       DROP TYPE - remove a data type


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


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

PARAMETERS
       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, but note that the CREATE TYPE command and the data type extension
       mechanisms in PostgreSQL differ from the SQL standard.

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



SQL - Language Statements	  2010-12-14			   DROP TYPE()
YoLinux.com Home Page
YoLinux Tutorial Index
Privacy Policy | Advertise with us | Feedback Form |
Unauthorized copying or redistribution prohibited.
    Bookmark and Share