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


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: