Applies To: SQL Server 2014, SQL Server 2016 Preview
Contains a row for each search property contained by any search property list on the current database.
Applies to: SQL Server (SQL Server 2012 through current version).
ID of the search property list to which this property belongs.
Globally unique identifier GUID that identifies the property set to which the search property belongs.
Integer that identifies this search property within the property set. property_int_id is unique within the property set.
Name that uniquely identifies this search property in the search property list.
Description of the property.
Internal property ID of the search property within the search property list identified by the property_list_id value.
When a given property is added to a given search property list, the Full-Text Engine registers the property and assigns it an internal property ID that is specific to that property list. The internal property ID, which is an integer, is unique to a given search property list. If a given property is registered for multiple search property lists, a different internal property ID might be assigned for each search property list.
To view all property-related content in the full-text index
For more information about search property lists, see Search Document Properties with Search Property Lists.
Visibility of the metadata for search properties is limited to those that are in search property lists that you either own or on which you have been granted some REFERENCE permission.
The search property list owner can grant REFERENCE or CONTROL permissions on the list. Users with CONTROL permission can also grant REFERENCE permission to other users.
The following example lists all of the metadata for registered search properties.
USE AdventureWorks2012; GO SELECT * FROM sys.registered_search_properties; GO