Export (0) Print
Expand All

Full-Text Data Definition Language (DDL)

SQL Server 2005

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft