What are the challenges you face when working across database platforms? Take the survey

Formatting without tables

bahrinkabahrinka Posts: 3
edited April 18, 2012 10:45AM in SQL Prompt Previous Versions
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?


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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?
  • Options
    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.
Sign In or Register to comment.