Formatting without tables

bahrinka

When I copy a large SQL statement from a remote database an error box pops up because the tables don't exist and formatting does not occur. Is there a way to force formatting even if the tables do not exist?

Brian Donahue

I don't think that the problem is caused by the tables not existing. At least on my SQL Prompt I can do a format SQL and include tables, schemas, and databases that do not exist on that server.

What is the exact error message please?

bahrinka

The exact error was: "SQL Prompt was unable to complete this operation. Problem areas have been highlighted.". However, I tried this morning and it did format even though the tables do not exist. So, I'll assume I had a syntax error in the last SQL statement I tried. Thanks for confirming that it should work.