CODEWITHSUNDEEP
mysqlsavemysql-workbenchworkbenchinformation-schema
learner
learner

Reputation: 316

How to save DB tables summary shown in MySQL workbench

I can see DB table details in MySQL Workbench, but can't find an option to save them. I also tried CTRL + A and CTRL + C but it didn't selected all the rows.

enter image description here

Upvotes: 0

Views: 120

Answers (1)

Sujan
Sujan

Reputation: 31

Hello Leaner: You can easily extract the DB tables summary. Just open-up SQL window, copy-paste the SQL and run.

SELECT TABLE_NAME, ENGINE, VERSION, ROW_FORMAT, TABLE_ROWS, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, 
DATA_FREE, AUTO_INCREMENT, CREATE_TIME, UPDATE_TIME, CHECK_TIME, TABLE_COLLATION, CHECKSUM, TABLE_COMMENT
FROM information_schema.Tables 
WHERE TABLE_SCHEMA = '<your-database-name'

Once you get the result grid, you will be able to find export option (having icon of floppy disk). Click and save your result.

Let me know the update. Cheers.

Update:

Once you get the result grid, you will see the button Export. Just click on it, you will be able to save the result.

enter image description here

Upvotes: 1

Related Questions