Viewing Table Data from the Data Sources Tool Window
You can access tables immediately from the Database tool window, without executing queries explicitly.
To view the structure of a table
- In the Database tool window, expand the desired data source node.
- Select the desired table and press Ctrl+Q.
IntelliJ IDEA opens a quick documentation look-up window, which displays the following information:
CREATE TABLEquery through which the table has been created.
- Results of executing the
SELECT * FROM table_namequery (the first 10 rows of the table).
Last modified: 3 February 2015