CODEWITHSUNDEEP
amazon-redshiftdatagrip
Chubaka
Chubaka

Reputation: 3155

DESCRIBE table equivalents in Datagrip?

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!

Upvotes: 5

Views: 6739

Answers (2)

Eugene
Eugene

Reputation: 6005

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

enter image description here

enter image description here

Upvotes: 0

moscas
moscas

Reputation: 10355

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

Upvotes: 7

Related Questions