20.7.Removing A Text Trigger

Prev	Up	Next
20.6.Removing A Text Index	Home	20.7.1.vt_drop_ftt_dedup

¶

Used to drop text trigger definition on text indexed table. The operation also drop all tables created by create text trigger statement.

Syntax:

DROP TEXT TRIGGER ON <table> [(<data_column>)]

Example20.7.Removing A Text Trigger

drop text trigger on ftt;

will drop the text trigger definition from table ftt.

Or using the stored procedure:

Prev	Up	Next
20.6.Removing A Text Index	Home	20.7.1.vt_drop_ftt_dedup

Prefix	Namespace IRI
schema	http://schema.org/
n2	http://docs.openlinksw.com/virtuoso/droptxttrig/
n5	http://creativecommons.org/licenses/by/4.0/deed.
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n4	http://www.openlinksw.com/#
xsdh	http://www.w3.org/2001/XMLSchema#

Namespace Prefix	Namespace URI
xmlns:schema	http://schema.org/
xmlns:n2	http://docs.openlinksw.com/virtuoso/droptxttrig/
xmlns:n5	http://creativecommons.org/licenses/by/4.0/deed.
xmlns:rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
xmlns:n4	http://www.openlinksw.com/#
xmlns:xsdh	http://www.w3.org/2001/XMLSchema#

Subject	Predicate	Object
n2:	rdf:type	schema:TechArticle
n2:	schema:name	20.7.ÃÂ Removing A Text Trigger
n2:	schema:copyrightHolder	_:vb78922
n2:	schema:datePublished	2016-09-09 16:16:54
n2:	schema:headline	20.7.ÃÂ Removing A Text Trigger
n2:	schema:keywords	OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data
n2:	schema:license	n5:en_US
n2:	schema:publisher	_:vb78921
n2:	schema:url	n2:
_:vb78921	rdf:type	schema:Organization
_:vb78921	schema:name	OpenLink Software
_:vb78921	schema:url	n4:this
_:vb78922	rdf:type	schema:Organization
_:vb78922	schema:name	OpenLink Software
_:vb78922	schema:url	n4:this