Existing SQL
Remove Output Columns
Remove a field from the final result while retaining columns that the query still needs internally.
Steps
1
Open Output Columns
Identify the field currently displayed in the result.
2
Open Review schema and update SQL
Locate the corresponding schema column and review its dependencies.
3
Remove or hide
Delete a column used only for display. Hide a column when joins, filters, grouping, sorting, or key logic still require it.
4
Verify the distinction
Confirm the field is absent from the SELECT output while required references remain elsewhere in the SQL.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.