DESCRIBE table equivalents in Datagrip?

Question

When I run "DESCRIBE table_name;" in SQLWORKBENCHJ for redshift, or mysqlworkbench for MySQL, it will list the columns of the table, primary key, foreign keys, etc. However, I don't find the equivalent in Datagrip. Is there any "DESCRIBE table_name;" in Datagrip? Thank you!

Deferment

see if this will work for you #38743200 – Hamnet

right click table, click sql scripts then generate ddl to ... – Vilify

Thanks! The problem of this way is that Datagrip only shows about 40% of the tables in our Amazon Redshift for unknown reasons and we think datagrip has bugs. @JonScott – Deferment

redshift works fine with datagrip. make sure you are on latest version of datagrip, make sure that all schemas are selected (manage shown schemas) - make sure you are using the redhsift driver and that it is the latest version. check your access rights (for the user id that you are using). make sure you have "refreshed". – Vilify

@Deferment please write at [email protected] and we'll investigate the problem – Derose

Answer 1

The best way to see the information about the table is to use QuickDoc (F1 for Mac or Ctrl+Q for Win/Linux)

Derose

Answer 2

IMHO, for large tables more usable is DDL definition: Ctrl+B
QuickDoc is a read-only window it is impossible to search thru this window, better to use a separate tab with DDL definition. The same info but a separate tab provides more features.
You can apply all features of the context menu for DDL definition like: Find Usages, Find in Files, Refactor, Search thru table definition

Swivel