2 doc/src/sgml/ref/drop_tstemplate.sgml
3 PostgreSQL documentation
6 <refentry id="SQL-DROPTSTEMPLATE">
7 <indexterm zone="sql-droptstemplate">
8 <primary>DROP TEXT SEARCH TEMPLATE</primary>
12 <refentrytitle>DROP TEXT SEARCH TEMPLATE</refentrytitle>
13 <manvolnum>7</manvolnum>
14 <refmiscinfo>SQL - Language Statements</refmiscinfo>
18 <refname>DROP TEXT SEARCH TEMPLATE</refname>
19 <refpurpose>remove a text search template</refpurpose>
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,
67 and in turn all objects that depend on those objects
68 (see <xref linkend="ddl-depend">).
74 <term><literal>RESTRICT</literal></term>
77 Refuse to drop the text search template if any objects depend on it.
86 <title>Examples</title>
89 Remove the text search template <literal>thesaurus</literal>:
92 DROP TEXT SEARCH TEMPLATE thesaurus;
95 This command will not succeed if there are any existing text search
96 dictionaries that use the template. Add <literal>CASCADE</> to
97 drop such dictionaries along with the template.
102 <title>Compatibility</title>
105 There is no <command>DROP TEXT SEARCH TEMPLATE</command> statement in the
111 <title>See Also</title>
113 <simplelist type="inline">
114 <member><xref linkend="sql-altertstemplate"></member>
115 <member><xref linkend="sql-createtstemplate"></member>