REFRESH TABLE METADATA

Description

The REFRESH TABLE METADATA syntax is used to refresh table metadata.

Syntax

RefreshTableMetadata ::=
  'REFRESH' 'TABLE' 'METADATA' (tableName | tableName 'FROM' 'STORAGE' 'UNIT' storageUnitName ('SCHEMA' schemaName)?)?

tableName ::=
  distSQLIdentifier

storageUnitName ::=
  distSQLIdentifier

schemaName ::=
  distSQLIdentifier

distSQLIdentifier ::=
  identifier | quotedIdentifier

quotedIdentifier ::=
  '`' identifier '`' | '"' identifier '"'

Supplement

• When tableName and storageUnitName is not specified, the default is to refresh all table metadata.

• refresh table metadata need to use DATABASE. If DATABASE is not used, No database selected will be prompted.

• If there are no tables in the schema, the schema will be deleted.

• tableName, storageUnitName, and schemaName can be unquoted identifiers, backtick-quoted identifiers, or double-quoted identifiers.

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

• Reserved word