DROP SEARCH PROPERTY LIST (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).
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.
Applies to: SQL Server (SQL Server 2012 through current version).
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
Requires CONTROL permission on the search property list.
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.
The following example drops the JobCandidateProperties property list from the AdventureWorks2012 database.
DROP SEARCH PROPERTY LIST JobCandidateProperties; GO