Full-Text Transact-SQL Enhancements

  • Article

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 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.

See Also

Reference

Data Definition Language (DDL) Statements (Transact-SQL)

Other Resources

What's New and Enhanced in Transact-SQL (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance