title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.endpoint_webmethods (Transact-SQL) |
sys.endpoint_webmethods (Transact-SQL) |
rwestMSFT |
randolphwest |
03/14/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
[!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 |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)