Home SQL Server Commands
 

DROP FULLTEXT INDEX

Remove a full-text catalog from a database.

Syntax
      DROP FULLTEXT INDEX ON table_name

Key:
    table_name  Table containing the Full Table Index

Example

DROP FULLTEXT INDEX ON TestSchema.SalesTable;
GO

"The greatest Christmas gift can't be purchased in a store, ordered from a catalog, wrapped in a pretty package with a fancy bow ... but it can be seen in the eyes of a child, heard in the words of kindness & felt in the embrace of a friend" - anon

Related commands:

CREATE FULLTEXT CATALOG
ALTER FULLTEXT INDEX

Equivalent Oracle commands:

Oracle Text / InterMedia / ConText



Back to the Top

Simon Sheppard
SS64.com