[TOC] # 修改租戶 ## 通過 SQL 語句修改租戶 修改租戶命令的語法如下： ~~~ ALTER TENANT {tenant_name | ALL} [SET] [tenant_option_list] [opt_global_sys_vars_set] tenant_option_list: tenant_option [, tenant_option ...] tenant_option: COMMENT [=]'string' |{CHARACTER SET | CHARSET} [=] charsetname |COLLATE [=] collationname |REPLICA_NUM [=] num |ZONE_LIST [=] (zone [, zone…]) |PRIMARY_ZONE [=] zone |RESOURCE_POOL_LIST [=](poolname [, poolname…]) |DEFAULT TABLEGROUP [=] {NULL | tablegroupname} |{READ ONLY | READ WRITE} |LOGONLY_REPLICA_NUM [=] num |LOCALITY [=] 'locality description' |LOCK|UNLOCK; opt_global_sys_vars_set: VARIABLES system_var_name = expr [,system_var_name = expr] ... ~~~ 鎖定租戶`TENANT1`的示例如下： ~~~ obclient> ALTER TENANT TENANT1 LOCK; ~~~ 更多`ALTER TENANT`語句的信息請參見[ALTER TENANT](https://open.oceanbase.com/docs/community/oceanbase-database/V3.1.0/alter-tenant)。