Use the following new Transact-SQL DDL statements to create, implement, and manage full-text catalogs and indexes. In earlier versions of Microsoft SQL Server, stored procedures are the main programmatic way to create and manage full-text catalogs and indexes. Although these stored procedures are supported for backward compatibility, new features in SQL Server 2005 are only available by using the DDL statements.
|
New statements
|
Description
|
|---|
|
CREATE FULLTEXT CATALOG
|
Creates a full-text catalog for the database.
|
|
ALTER FULLTEXT CATALOG
|
Changes the properties of a full-text catalog.
Use this statement to perform the following:
-
Rebuild the catalog, with or without accent-sensitivity.
-
Reorganize the indexes in the catalog.
-
Set the catalog as the default catalog.
|
|
DROP FULLTEXT CATALOG
|
Removes a full-text catalog from a database.
|
|
CREATE FULLTEXT INDEX
|
Creates a full-text index on one or more columns of a table in a database.
|
|
ALTER FULLTEXT INDEX
|
Changes the properties of a full-text index.
Use this statement to perform the following:
-
Enable or disable full-text indexing on a table.
-
Add or drop columns to a full-text index.
-
Start, with full, incremental, or update, or stop population of a full-text index.
|
|
DROP FULLTEXT INDEX
|
Removes a full-text index from a table.
|
Reference
Data Definition Language (DDL) Statements (Transact-SQL)
Other Resources
What's New and Enhanced in Transact-SQL (Transact-SQL)
Help and Information
Getting SQL Server 2005 Assistance