Menu
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?
754
In DataGrip, you could be looking for things like: — Database objects: tables, views, procedures, columns and so on. — Data: enough said. — Code: for example a piece of code in a big script or the source code for a database object.
To close the pane where the query is shown, press Escape. When you insert, delete, or modify data in a table editor, you can preview the query that DataGrip uses to perform selected operations. To preview the query, click the Preview pending changes button () on the toolbar.
You can view the structure of your databases and perform other tasks in the database explorer . Here are the advantages of the DataGrip database explorer that our users value most.
This tutorial will show you how to view foreign keys using DataGrip. From View -> Tool Windows in toolbar select Database (or press Alt + 1). Fig. 1. Database in toolbar In opened explorer search for table which foreign keys you want to see. You can identify foreign keys in two ways:
If I got you right, there are several ways to do what you want:
Ctrl+N (Cmd+O for Mac) → type the name of the table, press Enter
If the cursor is on the name of the table inside the script, press F4.
If the cursor is on the name of the table inside the DB explorer, you can double-clik it or press F4.
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.
In any place, wether it's SQL or database explorer, press Ctrl+Q (F1 for Mac) and you will see the quick documentation window.
110
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.
44
Double-clicking on a table in the left pane will open the data for the table.
3
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
