Export (0) Print
Expand All

sys.registered_search_property_lists (Transact-SQL)

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

Community Additions

ADD
Show:
© 2014 Microsoft