Skip to content

Add ability to remove blank space between results from multiple SELECT statements when the result is only 1 row #10862

Open
@Zigzagoon77

Description

@Zigzagoon77

Is your feature request related to a problem? Please describe.
When pulling a single row from multiple tables Azure creates a large blank space between each result row and the next. This isn't an issue when there are multiple rows in the results of a single SELECT statement, as then the rows will continue until they hit the next result set.

Describe the solution or feature you'd like
Create a more flexible result grid that adjusts to the size of less result rows.

Describe alternatives you've considered
While UNION can bring data from the two tables together into one result set, it comes with restrictions - such as losing column headers and only allowing the same amount of columns in each select statement. This is not a good solution when looking at an object that has data across many tables. JOINs are not a good solution either, as they put all data into a single row, making data difficult to view and compare as it stretches on horizontally. Pulling only certain columns from the different tables only works when you're interested in a handful of columns.

Additional context
Here's an example from a project I'm working on:
image

As you can see, there's a bunch of blank space between the select results.
It's possible a setting to adjust this already exists, but I was unable to find it within the settings, nor through different searches online. I recently switched from SQL server management studio where it automatically adjusts like so:
SQL Results

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions