REFRESH TABLE METADATA
Description
The REFRESH TABLE METADATA
syntax is used to refresh table metadata.
Syntax
Grammar Railroad diagram
RefreshTableMetadata ::=
'REFRESH' 'TABLE' 'METADATA' (tableName | tableName 'FROM' 'STORAGE' 'UNIT' storageUnitName ('SCHEMA' schemaName)?)?
tableName ::=
identifier
storageUnitName ::=
identifier
schemaName ::=
identifier
Supplement
When
tableName
andstorageUnitName
is not specified, the default is to refresh all table metadata.refresh table metadata need to use
DATABASE
. IfDATABASE
is not used,No database selected
will be prompted.If there are no tables in the schema, the schema will be deleted.
Example
- Refresh specified table’s metadata in specified schema of a specified storage unit
REFRESH TABLE METADATA t_order FROM STORAGE UNIT ds_1 SCHEMA db_schema;
- Refresh all tables’ metadata in specified schema of a specified storage unit
REFRESH TABLE METADATA FROM STORAGE UNIT ds_1 SCHEMA db_schema;
- Refresh metadata for specified table in specified storage unit
REFRESH TABLE METADATA t_order FROM STORAGE UNIT ds_1;
- Refresh metadata for specified table
REFRESH TABLE METADATA t_order;
- Refresh all table metadata
REFRESH TABLE METADATA;
Reserved word
REFRESH
, TABLE
, METADATA
, FROM
, STORAGE
, UNIT
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .