After some month of use I'm quite happy with DataGrip. There's some task which still force me to use my previous database client (SQLYog).
- Where I can find tables informations for a database? I look for something similar to the output of SHOW TABLE STATUS FROM mydb WHERE ENGINE IS NOT NULL; with info about sizes (data and indexes), row count, and the engine used, is there any in DataGrip?
- Same as above but for the host? Something like SHOW STATUS;
- On creating a table, is there a way to set the table engine other than manually adding the ENGINE clause in the statement?