SQL Prompt

Latest version: 5.3

SQL Prompt

Knowledge Base

A newly-created table exists, but it is not visible in the candidate list (version 3)

Category: Troubleshooting & error messages
Date: 30 Jul 2009
Product: SQL Prompt
Versions: 3.0-3.9

You may create a new table, and when you open a query window and invoke the candidate list shown by SQL Prompt, the candidate list may not show the new table as a candidate when the cursor is placed in the query at the point where a table name would normally be specified.

The problem is most likely SQL Prompt's cached schema information for the database being used is out of date. On the main menu click on SQL Prompt > Cache Management. Find the database you're interested in and either delete it from the cache or click Refresh (it is preferred to try to refresh the schema first). If you're working with databases whose schemas change regularly, we'd recommend checking the "Refresh the cache automatically" option. Doing this will mean that SQL Prompt will reload each database when it's first used after restarting your editor session.

Document ID: KB200708000103 Keywords: SQL, Prompt, new, table,candidate

Was this article helpful?

Search support
Forums
Visit the SQL Prompt forum.
Learning SQL Prompt
Knowledge base

SQL Prompt

all SQL products

all products

Notes & articles

SQL Prompt

all SQL products

all products

Demos & walkthroughs

SQL Prompt