2
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_type.sgml,v 1.26 2004-06-25 21:55:50 tgl Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-DROPTYPE">
8
<refentrytitle id="SQL-DROPTYPE-TITLE">DROP TYPE</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>DROP TYPE</refname>
14
<refpurpose>remove a data type</refpurpose>
17
<indexterm zone="sql-droptype">
18
<primary>DROP TYPE</primary>
23
DROP TYPE <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | RESTRICT ]
28
<title>Description</title>
31
<command>DROP TYPE</command> will remove a user-defined data type.
32
Only the owner of a type can remove it.
37
<title>Parameters</title>
41
<term><replaceable class="PARAMETER">name</replaceable></term>
44
The name (optionally schema-qualified) of the data type to remove.
50
<term><literal>CASCADE</literal></term>
53
Automatically drop objects that depend on the type (such as
54
table columns, functions, operators).
60
<term><literal>RESTRICT</literal></term>
63
Refuse to drop the type if any objects depend on it. This is
71
<refsect1 id="SQL-DROPTYPE-examples">
72
<title>Examples</title>
75
To remove the data type <type>box</type>:
82
<refsect1 id="SQL-DROPTYPE-compatibility">
83
<title>Compatibility</title>
86
This command is similar to the corresponding command in the SQL
87
standard, but note that the <command>CREATE TYPE</command> command
88
and the data type extension mechanisms in
89
<productname>PostgreSQL</productname> differ from the SQL standard.
93
<refsect1 id="SQL-DROPTYPE-see-also">
94
<title>See Also</title>
96
<simplelist type="inline">
97
<member><xref linkend="sql-createtype" endterm="sql-createtype-title"></member>
98
<member><xref linkend="sql-altertype" endterm="sql-altertype-title"></member>
104
<!-- Keep this comment at the end of the file
109
sgml-minimize-attributes:nil
110
sgml-always-quote-attributes:t
113
sgml-parent-document:nil
114
sgml-default-dtd-file:"../reference.ced"
115
sgml-exposed-tags:nil
116
sgml-local-catalogs:"/usr/lib/sgml/catalog"
117
sgml-local-ecat-files:nil