2 doc/src/sgml/ref/drop_tstemplate.sgml
3 PostgreSQL documentation
6 <refentry id="SQL-DROPTSTEMPLATE">
8 <refentrytitle>DROP TEXT SEARCH TEMPLATE</refentrytitle>
9 <manvolnum>7</manvolnum>
10 <refmiscinfo>SQL - Language Statements</refmiscinfo>
14 <refname>DROP TEXT SEARCH TEMPLATE</refname>
15 <refpurpose>remove a text search template</refpurpose>
18 <indexterm zone="sql-droptstemplate">
19 <primary>DROP TEXT SEARCH TEMPLATE</primary>
24 DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [ CASCADE | RESTRICT ]
29 <title>Description</title>
32 <command>DROP TEXT SEARCH TEMPLATE</command> drops an existing text search
33 template. You must be a superuser to use this command.
38 <title>Parameters</title>
43 <term><literal>IF EXISTS</literal></term>
46 Do not throw an error if the text search template does not exist.
47 A notice is issued in this case.
53 <term><replaceable class="parameter">name</replaceable></term>
56 The name (optionally schema-qualified) of an existing text search
63 <term><literal>CASCADE</literal></term>
66 Automatically drop objects that depend on the text search template.
72 <term><literal>RESTRICT</literal></term>
75 Refuse to drop the text search template if any objects depend on it.
84 <title>Examples</title>
87 Remove the text search template <literal>thesaurus</literal>:
90 DROP TEXT SEARCH TEMPLATE thesaurus;
93 This command will not succeed if there are any existing text search
94 dictionaries that use the template. Add <literal>CASCADE</> to
95 drop such dictionaries along with the template.
100 <title>Compatibility</title>
103 There is no <command>DROP TEXT SEARCH TEMPLATE</command> statement in the
109 <title>See Also</title>
111 <simplelist type="inline">
112 <member><xref linkend="sql-altertstemplate"></member>
113 <member><xref linkend="sql-createtstemplate"></member>