ALTER SERVICE service-name
[ TYPE { 'RAW' | 'HTML' | 'JSON' | 'XML' } ]
[ URL [ PATH ] { ON | OFF | ELEMENTS } ]
[ common-attributes ]
[ AS { statement | NULL } ]

common-attributes:
[ AUTHORIZATION { ON | OFF } ]
[ ENABLE | DISABLE ]
[ METHODS 'method,...' ]
[ SECURE { ON | OFF } ]
[ USER { user-name | NULL } ]

method:
DEFAULT
| POST
| GET
| HEAD
| PUT
| DELETE
| NONE
| *

ALTER SERVICE service-name
[ TYPE 'SOAP' ]
[ DATATYPE { ON | OFF | IN | OUT } ]
[ FORMAT { 'DNET' | 'CONCRETE' [ EXPLICIT { ON | OFF } ] | 'XML' | NULL } ]
[ common-attributes ]
[ AS statement ]

ALTER SERVICE service-name
[ TYPE 'DISH' ]
[ GROUP { group-name | NULL } ]
[ FORMAT { 'DNET' | 'CONCRETE' [ EXPLICIT { ON | OFF } ]| 'XML' | NULL } ]
[ common-attributes ]

对 ALTER SERVICE 子句的说明与对 CREATE SERVICE 语句的说明相同。请参见CREATE SERVICE 语句。

ALTER SERVICE 语句修改 Web 服务的属性。

DBA 特权

无。

• CREATE SERVICE 语句
• DROP SERVICE 语句
• 教程：使用 SQL Anywhere 访问 SOAP/DISH 服务
• SYSWEBSERVICE 系统视图
• -xs dbeng12/dbsrv12 服务器选项
• 将 SQL Anywhere 用作 HTTP Web 服务器

以下示例演示如何使用 ALTER SERVICE 语句禁用现有 Web 服务：

CREATE SERVICE WebServiceTable
   AUTHORIZATION OFF
   USER DBA
   AS SELECT *
      FROM SYS.SYSTAB;

ALTER SERVICE WebServiceTable DISABLE;