sys.registered_search_property_lists (Transact-SQL)
Contains a row for each search property list on the current database.
Column name |
Data type |
Description |
|---|---|---|
property_list_id |
int |
ID of the property list. |
name |
sysname |
Name of the property list. |
create_date |
datetime |
Date the property list was created. |
modify_date |
datetime |
Date the property list was last modified by any ALTER statement. |
principal_id |
int |
Owner of the property list. |
Remarks
For more information, see Search Document Properties with Search Property Lists.
Permissions
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.
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.
Examples
The following example displays the ID and name of the search property lists in the AdventureWorks database.
USE AdventureWorks;
GO
SELECT property_list_id, name FROM sys.registered_search_property_lists;
GO