sys.registered_search_property_lists (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains a row for each search property list on the current database.

Column nameData typeDescription
property_list_idintID of the property list.
namesysnameName of the property list.
create_datedatetimeDate the property list was created.
modify_datedatetimeDate the property list was last modified by any ALTER statement.
principal_idintOwner of the property list.

For more information, see Search Document Properties with Search Property Lists.

Visibility of the metadata in search property lists is limited to those that you either own or on which you have been granted some REFERENCE permission.

System_CAPS_ICON_note.jpg Note

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 displays the ID and name of the search property lists in the AdventureWorks2012 database.

USE AdventureWorks2012;  
SELECT property_list_id, name FROM sys.registered_search_property_lists;  

sys.fulltext_indexes (Transact-SQL)

Community Additions