DROP SEARCH PROPERTY LIST (Transact-SQL)
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.
Important
CREATE SEARCH PROPERTY LIST, ALTER SEARCH PROPERTY LIST, and DROP SEARCH PROPERTY LIST are supported only under compatibility level 110. Under lower compatibility levels, these statements are not supported.
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 Transact-SQL statement.
Examples
The following example drops the JobCandidateProperties property list from the AdventureWorks database.
USE AdventureWorks;
GO
DROP SEARCH PROPERTY LIST JobCandidateProperties;
GO
See Also
Reference
ALTER SEARCH PROPERTY LIST (Transact-SQL)
CREATE SEARCH PROPERTY LIST (Transact-SQL)
sys.registered_search_properties (Transact-SQL)
sys.registered_search_property_lists (Transact-SQL)
sys.registered_search_property_lists (Transact-SQL)