sys-registered-search-property-lists-transact-sql.md

title	sys.registered_search_property_lists (Transact-SQL)
description	sys.registered_search_property_lists (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.reviewer	mikeray
ms.date	06/10/2016
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	registered_search_property_lists_TSQL sys.registered_search_property_lists registered_search_property_lists sys.registered_search_property_lists_TSQL
helpviewer_keywords	full-text search [SQL Server], search property lists sys.registered_search_property_lists catalog view search property lists [SQL Server], viewing
dev_langs	TSQL

sys.registered_search_property_lists (Transact-SQL)

[!INCLUDE SQL Server]

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 [!INCLUDEssSampleDBnormal] database.

USE AdventureWorks2022;  
GO  
SELECT property_list_id, name FROM sys.registered_search_property_lists;  
GO  

See Also

ALTER FULLTEXT INDEX (Transact-SQL)
sys.fulltext_indexes (Transact-SQL)