DROP ENDPOINT (Transact-SQL)

Applies to: SQL Server (all supported versions)

Drops an existing endpoint.

Topic link icon Transact-SQL Syntax Conventions

Syntax

DROP ENDPOINT endPointName  

Note

To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.

Arguments

endPointName
Is the name of the endpoint to be removed.

Remarks

The ENDPOINT DDL statements cannot be executed inside a user transaction.

Permissions

User must be a member of the sysadmin fixed server role, the owner of the endpoint, or have been granted CONTROL permission on the endpoint.

Examples

The following example removes a previously created endpoint called sql_endpoint.

DROP ENDPOINT sql_endpoint;  

See Also

CREATE ENDPOINT (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
EVENTDATA (Transact-SQL)