Drops an existing endpoint.
DROP ENDPOINT endPointName
Is the name of the endpoint to be removed.
The ENDPOINT DDL statements cannot be executed inside a user transaction.
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.
The following example removes a previously created endpoint called
DROP ENDPOINT sql_endpoint;