Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Full-Text Transact-SQL Enhancements

SQL Server 2005

Use the following new Transact-SQL DDL statements to create, implement, and manage full-text catalogs and indexes. In earlier versions of Microsoft SQL Server, stored procedures are the main programmatic way to create and manage full-text catalogs and indexes. Although these stored procedures are supported for backward compatibility, new features in SQL Server 2005 are only available by using the DDL statements.

New statements Description

CREATE FULLTEXT CATALOG

Creates a full-text catalog for the database.

ALTER FULLTEXT CATALOG

Changes the properties of a full-text catalog.

Use this statement to perform the following:

  • Rebuild the catalog, with or without accent-sensitivity.
  • Reorganize the indexes in the catalog.
  • Set the catalog as the default catalog.

DROP FULLTEXT CATALOG

Removes a full-text catalog from a database.

CREATE FULLTEXT INDEX

Creates a full-text index on one or more columns of a table in a database.

ALTER FULLTEXT INDEX

Changes the properties of a full-text index.

Use this statement to perform the following:

  • Enable or disable full-text indexing on a table.
  • Add or drop columns to a full-text index.
  • Start, with full, incremental, or update, or stop population of a full-text index.

DROP FULLTEXT INDEX

Removes a full-text index from a table.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.