How can we help you today? How can we help you today?

Adding new objects to database cache

hehe Another one...

If you create a new object in sql such as

create view vw_testing
as
select * from table

the new object (view) is not added to SQL Prompts cache and I have to refresh the cache manually to get the view to show up in the candidate list.

I dont know if there is anything that you can do about it but the same goes for if I create a table from SQL Server Management Studio GUI.
johnw
0

Comments

3 comments

Sort by
  • tgoldstein
    I have run into this problem also. How do you manually refresh the cache?

    Tim
    Denver, CO
    tgoldstein
    0
  • johnw
    From the "SQL Prompt" menu at the top of your editor click "Cache Management"
    johnw
    0
  • Tilman
    Hi,

    I'm afraid this is by design. We do not detect at the moment when the schema changes.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.