sys-endpoint-webmethods-transact-sql.md

title	sys.endpoint_webmethods (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	system-objects
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.endpoint_webmethods_TSQL sys.endpoint_webmethods endpoint_webmethods_TSQL sys.http_soap_methods_TSQL endpoint_webmethods sys.http_soap_methods
dev_langs	TSQL
helpviewer_keywords	sys.endpoint_webmethods catalog view
ms.assetid	7dad0cf6-eafa-47cf-98cc-75ba8d3c7959
caps.latest.revision	37
author	edmacauley
ms.author	edmaca
manager	craigg

sys.endpoint_webmethods (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

[!INCLUDEssNoteDepFutureAvoid]

Contains a row FOR EACH SOAP method defined on a SOAP-enabled HTTP endpoint. The combination of the endpoint_id and namespace columns is unique.

Column name	Data type	Description
endpoint_id	int	ID of the endpoint that the webmethod is defined on.
namespace	nvarchar(384)	Namespace for the webmethod.
method_alias	nvarchar(64)	Alias for the method. Note: [!INCLUDEtsql] identifiers allow characters that are not legal in WSDL method names. The alias is used to map the name exposed in the WSDL description of the endpoint to the actual underlying [!INCLUDEtsql] executable object that is called when the webmethod is invoked.
object_name	nvarchar(776)	The object name that the webmethod is redirected to, as specified in the NAME = option. Name parts are separated by a period (.), and delimited using brackets, [``]. The object name must be a three-part name, as specified in the WSDL option.
result_schema	tinyint	Option that determines which, if any, XSD is sent back with a response. 0 = None 1 = Standard 2 = Default
result_schema_desc	nvarchar(60)	Description of option that determines which, if any, XSD is sent back with a response. NONE STANDARD DEFAULT
result_format	tinyint	Option that determines how results are formatted in the response. 1 = ALL_RESULTS 2 = ROWSETS_ONLY 3 = NONE
result_format_desc	nvarchar(60)	Description of the option that determines how results are formatted in the response. ALL_RESULTS ROWSETS_ONLY NONE

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)