2 doc/src/sgml/ref/drop_tsdictionary.sgml
3 PostgreSQL documentation
6 <refentry id="SQL-DROPTSDICTIONARY">
8 <refentrytitle>DROP TEXT SEARCH DICTIONARY</refentrytitle>
9 <manvolnum>7</manvolnum>
10 <refmiscinfo>SQL - Language Statements</refmiscinfo>
14 <refname>DROP TEXT SEARCH DICTIONARY</refname>
15 <refpurpose>remove a text search dictionary</refpurpose>
18 <indexterm zone="sql-droptsdictionary">
19 <primary>DROP TEXT SEARCH DICTIONARY</primary>
24 DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [ CASCADE | RESTRICT ]
29 <title>Description</title>
32 <command>DROP TEXT SEARCH DICTIONARY</command> drops an existing text
33 search dictionary. To execute this command you must be the owner of the
39 <title>Parameters</title>
44 <term><literal>IF EXISTS</literal></term>
47 Do not throw an error if the text search dictionary does not exist.
48 A notice is issued in this case.
54 <term><replaceable class="parameter">name</replaceable></term>
57 The name (optionally schema-qualified) of an existing text search
64 <term><literal>CASCADE</literal></term>
67 Automatically drop objects that depend on the text search dictionary.
73 <term><literal>RESTRICT</literal></term>
76 Refuse to drop the text search dictionary if any objects depend on it.
85 <title>Examples</title>
88 Remove the text search dictionary <literal>english</literal>:
91 DROP TEXT SEARCH DICTIONARY english;
94 This command will not succeed if there are any existing text search
95 configurations that use the dictionary. Add <literal>CASCADE</> to
96 drop such configurations along with the dictionary.
101 <title>Compatibility</title>
104 There is no <command>DROP TEXT SEARCH DICTIONARY</command> statement in the
110 <title>See Also</title>
112 <simplelist type="inline">
113 <member><xref linkend="sql-altertsdictionary"></member>
114 <member><xref linkend="sql-createtsdictionary"></member>