Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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