drop-endpoint-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
DROP ENDPOINT (Transact-SQL)	DROP ENDPOINT (Transact-SQL)	markingmyname	maghan	03/06/2017	sql	t-sql	reference	DROP_ENDPOINT_TSQL DROP ENDPOINT	removing endpoints endpoints [SQL Server], removing deleting endpoints DROP ENDPOINT statement dropping endpoints	TSQL

DROP ENDPOINT (Transact-SQL)

[!INCLUDE SQL Server]

Drops an existing endpoint.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DROP ENDPOINT endPointName  

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)