Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Lists the Transact-SQL statements and the SQL Server database objects that support full-text search, including the property search feature.
This list doesn't include deprecated objects.
For the list of database objects that support semantic search, see Semantic Search DDL, Functions, Stored Procedures, and Views.
Transact-SQL Data Definition Language (DDL) statements
Use these statements to define, modify, and remove full-text search components such as catalogs, indexes, stoplists, and property lists. Typically, you use these statements when preparing a database or table for full-text search or when updating its configuration.
| Component | Create | Alter | Drop |
|---|---|---|---|
| Full-text catalog: Define a logical container for full-text indexes. | CREATE | ALTER | DROP |
| Full-text index: Define on a table column to enable full-text querying. | CREATE | ALTER | DROP |
| Full-text stoplist: Define a list of words to be ignored during full-text indexing. | CREATE | ALTER | DROP |
| Search property list: Defines a mapping of document property names to MIME types for use in property search. | CREATE | ALTER | DROP |
System predicates and functions
Full-text search extends Transact-SQL with predicates and table-valued functions that you can use to perform sophisticated text matching in queries.
| Object | Description |
|---|---|
| CONTAINS | Predicate that tests whether specified text values meet full-text criteria (for example, words or phrases). |
| CONTAINSTABLE | Table-valued function returning key values and rank of qualifying rows for a full-text query. |
| FREETEXT | Predicate that matches text values against a natural-language search phrase. |
| FREETEXTTABLE | Table-valued function similar to FREETEXT, returning ranking information. |
System metadata functions
These functions return metadata values related to full-text search or object properties. They're also used more broadly throughout SQL Server metadata queries.
| Object | Description |
|---|---|
| COLUMNPROPERTY | Returns information about a column's properties (for example, whether it is computed). |
| FULLTEXTCATALOGPROPERTY | Returns property values for a full-text catalog. |
| FULLTEXTSERVICEPROPERTY | Returns values for full-text service configuration. |
| INDEXPROPERTY | Returns information about an index. |
| OBJECTPROPERTY | Returns information about database objects. |
| OBJECTPROPERTYEX | Similar to OBJECTPROPERTY with extended property types. |
| SERVERPROPERTY | Returns information about the SQL Server instance. |
System stored procedures
These stored procedures support management and diagnostic operations for full-text search subsystems.
| Object | Description |
|---|---|
| sp_fulltext_keymappings | Reports mappings between full-text keys and index entries. This information is useful for understanding how key values relate to full-text indexes. |
| sp_fulltext_load_thesaurus_file | Loads a thesaurus file for full-text search. Thesaurus files provide synonyms and expansions. |
| sp_fulltext_pendingchanges | Returns size or estimated status of pending full-text index changes. |
| sp_fulltext_service | Provides administrative control over the full-text search service settings. |
| sp_help_fulltext_system_components | Lists full-text search system components and their status. |
System catalog views
These views expose full-text search metadata defined in the database schema.
| Object | Description |
|---|---|
| sys.fulltext_catalogs | Lists full-text catalogs defined in the database. |
| sys.fulltext_document_types | Shows document types registered for full-text indexing. |
| sys.fulltext_index_catalog_usages | Shows associations between full-text indexes and catalogs. |
| sys.fulltext_index_columns | Lists the columns participating in full-text indexes. |
| sys.fulltext_index_fragments | Provides fragmentation metadata for full-text indexes. |
| sys.fulltext_indexes | Lists tables that have a full-text index and key index information. |
| sys.fulltext_languages | Lists languages supported for full-text indexing. |
| sys.fulltext_stoplists | Lists stoplists available in the database. |
| sys.fulltext_stopwords | Lists stopwords defined in custom stoplists. |
| sys.fulltext_system_stopwords | Lists system stopwords built into SQL Server. |
| sys.registered_search_properties | Lists search properties registered for property search. |
| sys.registered_search_property_lists | Lists property lists used by property search. |
System dynamic management views
These DMVs provide real-time monitoring and internal status information related to full-text indexing and population.
| Object | Description |
|---|---|
| sys.dm_fts_active_catalogs | Shows full-text catalogs currently active. |
| sys.dm_fts_fdhosts | Details host processes supporting full-text indexing. |
| sys.dm_fts_index_keywords | Lists keywords stored in full-text indexes. |
| sys.dm_fts_index_keywords_by_document | Keywords mapped by document. |
| sys.dm_fts_index_keywords_by_property | Keywords mapped by registered property. |
| sys.dm_fts_index_population | Tracks population status of full-text indexes. |
| sys.dm_fts_memory_buffers | Shows memory buffer usage for full-text indexing. |
| sys.dm_fts_memory_pools | Provides memory pool statistics for full-text search. |
| sys.dm_fts_outstanding_batches | Reports outstanding index update batches. |
| sys.dm_fts_parser | Examines how text is parsed into tokens for full-text indexing. |
| sys.dm_fts_population_ranges | Shows ranges of data being processed during index population. |