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>