CODEWITHSUNDEEP
datagrip
Tgo1014
Tgo1014

Reputation: 576

How to quick view tables in DataGrip?

In sql express I could setup query shortcuts, so I simply create a "Select * from " shortcut and when I press it with the table name selected it shows me the select result

There's any way I can quick view the table content selecting only the table name in a script?

Upvotes: 17

Views: 22104

Answers (4)

Z41N
Z41N

Reputation: 107

in console tab > type sel > press tab > type your table name > hit enter

coming from mysql, i was looking for something quick like this too for datagrip. yea takes a few more actions but its actually quicker than clicking now so i can accept this, plus jetbrains suite overall is amazing so i have no problem doing this now

Upvotes: 0

moscas
moscas

Reputation: 10355

If I got you right, there are several ways to do what you want:

  1. Ctrl+N (Cmd+O for Mac) → type the name of the table, press Enter

  2. If the cursor is on the name of the table inside the script, press F4.

  3. If the cursor is on the name of the table inside the DB explorer, you can double-click it or press F4.

  4. If you are in the query console, the quick way to type "SELECT * FROM" is to type "sel" and press Tab. Then put the name of the table and run the query.

  5. In any place, whether it's SQL or database explorer, press Ctrl+Q (F1 for Mac) and you will see the quick documentation window.

Upvotes: 25

Ramin Melikov
Ramin Melikov

Reputation: 1005

Double-clicking on a table in the left pane will open the data for the table.

Upvotes: 4

mucio
mucio

Reputation: 7119

Another quick solution can be to put your cursor in the name of your table and press CTRL+Q, this will open the quick documentation, it will show the table structure with the first 10 rows at the end.

I find this faster than running the query.

Upvotes: 12

Related Questions