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: