Toad World® Forums

Single-Row View when no records

If you select from a table that returns zero rows, you see all the columns in the data grid, with no records. But, you can’t switch to Single-Row view. I like to do this to sort on the column names to see if a certain column name exists (many tables I work with have a couple hundred columns). I’d like to be able to do with even if the query returns no records.

Thanks.

-Charlie

Hi Charlie,

You can swith to Columns tab in the right-hand side Toolbox. It will show you the list of columns and you can sort them too.

Thanks,

Vincent

Yes, I can do that. It would be nice to be able to do it in Single-View as well (because this is what I use when there is data), but the Columns tab will work.

Thanks.

-Charlie

Hi Charlie,

I created story PT51779207 for this. We will let you know when we can implement it.

Thanks,

Vincent