When I use SHOW CREATE VIEW in MemSQL Studio or my Toad Data Point client, the SQL is returned as one line without any formatting, which makes it very difficult to interpret and maintain. How does everyone else deal with this? I searched Google for SQL formatter and tested a few. Among them, I like sqlformat.org the best because it uses a concise format and has an easy-to-remember URL. Others don’t like MemSQL’s keywords, use excessive indenting, etc.
I’ve used this one occasionally with good success:
1 Like
I did find that one to work as well. At least with my example view SQL, the formatting was less concise than I like compared with sqlformat.org.