DROP FULLTEXT CATALOG (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Removes a full-text catalog from a database. You must drop all full-text indexes associated with the catalog before you drop the catalog.
Transact-SQL syntax conventions
Syntax
DROP FULLTEXT CATALOG catalog_name
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
catalog_name
Is the name of the catalog to be removed. If catalog_name does not exist, Microsoft SQL Server returns an error and does not perform the DROP operation. The filegroup of the full-text catalog must not be marked OFFLINE or READONLY for the command to succeed.
Permissions
User must have DROP permission on the full-text catalog or be a member of the db_owner, or db_ddladmin fixed database roles.
See Also
sys.fulltext_catalogs (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
Full-Text Search
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें