How to pretty-print SHOW CREATE VIEW output in MySQL CLI?

Asked Apr 18 '19 at 15:14

Active Apr 18 '19 at 15:14

Viewed 632 times

You can run SHOW CREATE VIEW someview; to see the view definition. However, MySQL returns the definition without line breaks making it very hard to read.

Doing SHOW CREATE VIEW someview \G is slightly better as it doesn't result in multiple lines of table borders filling up the screen (--------------)

Is there a way to print the view definition more readable, with line breaks?

asked Apr 18 '19 at 15:14

Tobias Mühl

1,788
1
18
30

Did you try this: https://dba.stackexchange.com/questions/170610/how-to-retrieve-the-query-i-used-to-create-a-view – clinomaniac Apr 18 '19 at 16:55
@clinomaniac Yes, it shows the view definition but is barely readable. Please read the question.. – Tobias Mühl Apr 18 '19 at 17:10

How to pretty-print SHOW CREATE VIEW output in MySQL CLI?

0 Answers0