This process validates a table structure in the metadata against the table in the database.
Select one or more tables and click the Validate Selected button or click the Validate All button to validate all the tables.
- If a table is found to be different then it can be altered by using the right-click menu option when positioned over the table name.
- If the update date and the modified database date imply a change that is not apparent then these dates can be re-synced in the same way.
Sync Column order with database
Right-click on the result set and select Sync Column order with database to reorder the metadata columns to match the column order in the database table.
Sending Results to Microsoft Excel
Right-click on the result set and click Output to File to send the results of this report to Microsoft Excel.