The internal property ID is likely to be different from the property integer identifier of the property. The internal property ID for the Title property is 1, and the internal property ID for the Tags property is 2. The Full-Text Engine arbitrarily maps each property to an internal property ID that is unique to the search property list. The property integer identifiers are 2 for Title and 5 for Tags (Keywords). The property-list name for Keywords is 'Tags.' These properties belong to the same property set, whose GUID is F29F85E0-4FF9-1068-AB91-08002B27B3D9. The following illustration shows a logical view of a search property list that specifies two properties, Title and Keywords. The internal property ID is an integer that uniquely identifies the property in that search property list. When a property is registered for a search list, the Full-Text Engine arbitrarily assigns an internal property ID to the property. Therefore, if a property is added to multiple search property lists, its internal property ID is likely to differ between different lists. The Full-Text Engine arbitrarily assigns each registered property an internal property ID, which uniquely identifies the property in that particular search list and which is specific to that search property list. How Full-Text Search Works with Search Properties Internal Property IDs On the other hand, the XML IFilter does not emit properties. Among IFilters that extract a number of document properties are the IFilters for Microsoft Office document types (such as. You can configure a full-text index to support property searching only on properties that are extracted by an IFilter during full-text indexing. For some document types, the associated IFilter extracts some or all of the properties defined for that type of document, as well as the content of the document body. The associated filter (IFilter) determines whether property searching is possible on a specific type of document.

This form of searching is known as property searching. Now, however, you can configure a full-text index to support property-scoped searching on particular properties, such as Author and Title, for supported document types in a varbinary, varbinary(max) (including FILESTREAM), or image binary data column. This limitation restricted full-text queries to generic searches on whole documents. The content of document properties was previously indistinguishable from the content of the document body.

Applies to: SQL Server (all supported versions) Azure SQL Database

Find document properties word