The MSCK REPIAR DATABASE statement is used to synchronize the schemas of the underlying data source to Data Lake Analytics (DLA). If a table is deleted from the underlying data source, the MSCK REPIAR DATABASE statement automatically deletes the table from DLA. If a table is created in the underlying data source, the MSCK REPIAR DATABASE statement automatically adds the table to DLA. 

MSCK REPAIR DATABASE db_name

Example

;msck repair database db001

Usage notes

If the underlying data source is AnalyticDB for PostgreSQL, a database in AnalyticDB for PostgreSQL may have multiple schemas, and these schemas may have tables with identical names. In this case, the MSCK REPIAR DATABASE statement identifies tables only in the public schema.