To update the cached information for one or more available tables (if source tables change, for example), you can:
Clear and repopulate the Available Tables list using the Clear existing list option on the Refresh Available Tables dialog.
Update the cached information for an individual available table by selecting Refresh and then This Table Only from the table’s context menu.
Refresh multiple available tables by selecting each of the tables in the Connect CDC Director tree and selecting Refresh > All Checked Tables from the context menu of any of the tables.
Refresh all the available tables for the server by selecting Refresh All Tables in Cache from the server’s Available Tables context menu (or from the context menu of an individual table owner or database header sub-branch).
If tables have changed the updated list of available tables may include:
Tables that are no longer present or accessible on the host
These tables are marked with a red question mark (?). They may have been dropped from the sever or become unavailable to the Connect CDC Director due to security changes. You can add such a table to the server, alter the table’s security, or use the Remove from Cache context menu option to delete it from the model.
Tables with new or different columns, indexes, or attributes
The Connect CDC Director Catalog synchronization report shows these differences.