Skip to content

drop-search-property-list-transact-sql.md

Latest commit

 

History

History
88 lines (67 loc) · 4.09 KB

drop-search-property-list-transact-sql.md

File metadata and controls

88 lines (67 loc) · 4.09 KB
title DROP SEARCH PROPERTY LIST (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
DROP_SEARCH_PROPERTY_LIST_TSQL
DROP SEARCH PROPERTY LIST
dev_langs
TSQL
helpviewer_keywords
full-text search [SQL Server], search property lists
DROP SEARCH PROPERTY LIST statement
search property lists [SQL Server], dropping
search property lists [SQL Server], deleting
ms.assetid 7c7ce52a-6b77-4a1c-9abf-d5feb664bea8
caps.latest.revision 23
author BYHAM
ms.author rickbyh
manager jhubbard

DROP SEARCH PROPERTY LIST (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]

Drops a property list from the current database if the search property list is currently not associated with any full-text index in the database.

Syntax

  
DROP SEARCH PROPERTY LIST property_list_name  
;

Arguments

property_list_name
Is the name of the search property list to be dropped. property_list_name is an identifier.

To view the names of the existing property lists, use the sys.registered_search_property_lists catalog view, as follows:

SELECT name FROM sys.registered_search_property_lists;

Remarks

You cannot drop a search property list from a database while the list is associated with any full-text index, and attempts to do so fail. To drop a search property list from a given full-text index, use the ALTER FULLTEXT INDEX statement, and specify the SET SEARCH PROPERTY LIST clause with either OFF or the name of another search property list.

To view the property lists on a server instance

To view the property lists associated with full-text indexes

To remove a property list from a full-text index

Permissions

Requires CONTROL permission on the search property list.

Note

The property list owner can grant CONTROL permissions on the list. By default, the user who creates a search property list is its owner. The owner can be changed by using the ALTER AUTHORIZATION[!INCLUDEtsql] statement.

Examples

The following example drops the JobCandidateProperties property list from the AdventureWorks2012 database.

DROP SEARCH PROPERTY LIST JobCandidateProperties;  
GO

See Also

ALTER SEARCH PROPERTY LIST (Transact-SQL)
CREATE SEARCH PROPERTY LIST (Transact-SQL)
Search Document Properties with Search Property Lists
sys.registered_search_properties (Transact-SQL)
sys.registered_search_property_lists (Transact-SQL)
sys.registered_search_property_lists (Transact-SQL)