Database Structure
Review Tables and Columns
Confirm that imported tables and columns accurately represent the database structure needed by the workspace.
Steps
1
Open Review Schema
Use the schema review control after extracting, uploading, or building a schema.
2
Check names and data types
Compare each table and column with the source metadata or database documentation.
3
Review keys
Confirm primary keys, foreign-key targets, and connecting columns.
4
Remove irrelevant structure
Keep the workspace focused on the tables and fields needed for its queries.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.