REFRESH DATABASE METADATA FROM GOVERNANCE CENTER

Description

The REFRESH DATABASE METADATA FROM GOVERNANCE CENTER syntax is used to pull the latest configuration from the governance center and refresh the metadata of the local logic database.

Syntax

Grammar Railroad diagram

RefreshDatabaseMetadataFromGovernanceCenter ::=
  'REFRESH' 'DATABASE' 'METADATA' databaseName? 'FROM' 'GOVERNANCE' 'CENTER'
databaseName ::=
  identifier

Supplement

• When databaseName is not specified, the default is to refresh all database metadata.

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

Example

• Refresh metadata for specified database

REFRESH DATABASE METADATA sharding_db FROM GOVERNANCE CENTER;

• Refresh all database metadata

REFRESH DATABASE METADATA FROM GOVERNANCE CENTER;

Reserved word

REFRESH, DATABASE, METADATA, FROM, GOVERNANCE, CENTER

Related links

• Reserved word