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