¶
20.7. Removing A Text Trigger
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>)]
Example 20.7. Removing A Text Trigger
drop text trigger on ftt;
will drop the text trigger definition from table ftt.
Or using the stored procedure:
¶
20.7.1. vt_drop_ftt_dedup
For detailed description and example use of the function, see vt_drop_ftt in the Functions Reference Guide.