Is there a way to see what SQL was run to get the data in the data grid? (4245463)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Is there a way to see what SQL was run to get the data in the data grid?
Beschreibung

Is it possible to see what SQL was run to get the data in the data grid? There are times when there are multiple statements in one editor and it would be nice to be able to see which one was run to get the data.
Lösung

RESOLUTION #1:
The Editor has a Query Viewer panel. It shows all queries executed using F9. The most recent one will be the SQL that generated the results in the data grid. If the Query Viewer panel is not visible, it can be shown via rt-click menu, see the Desktop flyout.

RESOLUTION #2:
Click the 'Export Dataset' icon in the Data Grid toolbar or right click and select it from the menu. Then, when the Export Wizard appears, select the Dataset tab and you will see the SQL that was run to get the results in the data grid.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel