REFRESH TABLE METADATA FROM STORAGE UNIT

Description

The REFRESH TABLE METADATA FROM STORAGE UNIT syntax is used to Refresh the tables’ metadata in a schema of a specified storage unit.

Syntax

  1. RefreshTableMetadataFromStorageUnit ::=
  2.   'REFRESH' 'TABLE' 'METADATA' 'FROM' 'STORAGE' 'UNIT' storageUnitName 'SCHEMA' schemaName
  4. storageUnitName ::=
  5.   identifier
  7. schemaName ::=
  8.   identifier

Supplement

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

Example

  • Refresh the tables’ metadata in a schema of a specified storage unit
  1. REFRESH TABLE METADATA FROM STORAGE UNIT su_1 SCHEMA db_schema;

Reserved word

REFRESH, TABLE, METADATA, FROM, STORAGE, UNIT, SCHEMA