DROP AGGREGATE (Transact-SQL)
Applies to:
SQL Server
Azure SQL Managed Instance
Removes a user-defined aggregate function from the current database. User-defined aggregate functions are created by using CREATE AGGREGATE.
Transact-SQL syntax conventions
Syntax
DROP AGGREGATE [ IF EXISTS ] [ schema_name . ] aggregate_name
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
IF EXISTS
Applies to: SQL Server ( SQL Server 2016 (13.x) through current version).
Conditionally drops the aggregate only if it already exists.
schema_name
Is the name of the schema to which the user-defined aggregate function belongs.
aggregate_name
Is the name of the user-defined aggregate function you want to drop.
Remarks
DROP AGGREGATE does not execute if there are any views, functions, or stored procedures created with schema binding that reference the user-defined aggregate function you want to drop.
Permissions
To execute DROP AGGREGATE, at a minimum, a user must have ALTER permission on the schema to which the user-defined aggregate belongs, or CONTROL permission on the aggregate.
Examples
The following example drops the aggregate Concatenate
.
DROP AGGREGATE dbo.Concatenate;
See Also
CREATE AGGREGATE (Transact-SQL)
Create User-defined Aggregates
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें