Database Structure
Remove Unnecessary Columns
Reduce workspace scope by removing schema columns that are not needed for SQL generation or query logic.
Steps
1
Open Review Schema
Review columns table by table.
2
Check dependencies
Confirm the column is not required for a relationship, filter, grouping, calculation, or planned output.
3
Remove the field
Use the close control for removable columns and confirm the action.
4
Review affected SQL
Regenerate or update queries that previously referenced the removed field.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.