The REFRESH TABLE METADATA syntax is used to refresh table metadata.
RefreshTableMetadata ::=
'REFRESH' 'TABLE' 'METADATA' ( (tableName)? | tableName 'FROM' 'STORAGE' 'UNIT' storageUnitName)?
tableName ::=
identifier
storageUnitName ::=
identifier
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.
REFRESH TABLE METADATA t_order FROM STORAGE UNIT su_1;
REFRESH TABLE METADATA t_order;
REFRESH TABLE METADATA;
REFRESH, TABLE, METADATA, FROM, STORAGE, UNIT