Export (0) Print
Expand All

sys.registered_search_property_lists (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Applies to: SQL Server (SQL Server 2012 through current version.

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.

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 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;
GO
SELECT property_list_id, name FROM sys.registered_search_property_lists;
GO
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft