Full-Text Transact-SQL Enhancements

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