TechNet
Expand All
The document is archived and information here might be outdated

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.

Show:
© 2016 Microsoft