Full-Text Data Definition Language (DDL)

Microsoft SQL Server 2005 introduces new Transact-SQL data definition language (DDL) statements for creating, implementing, and managing full-text catalogs and indexes. The following is a list of the new Full-Text Search DDL statements.

• CREATE FULLTEXT CATALOG (Transact-SQL)
  Use this to create a full-text catalog for a database.

• CREATE FULLTEXT INDEX (Transact-SQL)
  Use this to create a full-text index on one or more columns of a table in a database.

• ALTER FULLTEXT CATALOG (Transact-SQL)
  Use this to change the properties of a full-text catalog.

• ALTER FULLTEXT INDEX (Transact-SQL)
  Use this to change the properties of a full-text index.

• DROP FULLTEXT CATALOG (Transact-SQL)
  Use this to delete a full-text catalog.

• DROP FULLTEXT INDEX (Transact-SQL)
  Use this to delete a full-text index from a specified table.

See Also

Concepts

Getting Started with Full-Text Search

Help and Information

Getting SQL Server 2005 Assistance