sys.fulltext_document_types (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns a row for each document type that is available for full-text indexing operations. Each row represents the IFilter interface that is registered in the instance of SQL Server.
Column name | Data type | Description |
---|---|---|
document_type | sysname | The file extension of the supported document type. This value can be used to identify the filter that will be used during full-text indexing of columns of type varbinary(max) or image. |
class_id | uniqueidentifier | GUID of the IFilter class that supports file extension. |
path | nvarchar(260) | The path to the IFilter DLL. The path is only visible to members of the serveradmin fixed server role. |
version | sysname | Version of the IFilter DLL. |
manufacturer | sysname | Name of the IFilter manufacturer. Note: Only documents with the manufacturer as Microsoft are supported on SQL Database. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.
See Also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें