Options

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?
· Share on Twitter

Comments

  • 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?
    · Share on Twitter
  • Options
    bahrinkabahrinka Posts: 3
    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.
    · Share on Twitter
Sign In or Register to comment.