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?
Comments
2 comments
-
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? -
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.
Add comment
Please sign in to leave a comment.