DB Test Driven

 

DBTD_DROP_FULLTEXT_INDEX_IF_EXISTS

Procedure will check if full text index exist for the specified table and will attempt to drop the full text index.

Arguments

  • v_Object_Name – name of a table or indexed view for which full text index need to be removed, SYSNAME

Note:Supported in SQL Server versions only.
 

Examples

  SQL Server

      EXEC DBTD_DROP_FULLTEXT_INDEX_IF_EXISTS 'MY_TABLE';

 

See Also


 

http://www.dbtestdriven.com/dbtd_drop_fulltext_index_if_exists.aspx