I am new to working with SQL Server, so this might be a newbie question. I am importing tables from one database to another without problems. I am manipulating those newly imported tables, creating newer versions and discarding the old. During some of my routine, it seems that before I can send the next function, the database needs to refresh the table view to realize that the referenced table exists. I have been right-clicking on the database in the GUI and selecting 'Refresh' in the context menu. I would like to have the db refresh automatically after the DROP TABLE function runs. How does one force a refresh through sql? cheers,

You probably refer to the SQL Server Management Studio (SSMS), not the database itself. SSMS caches the database objects state thus needs to be refreshed. I cannot think of any means to refreshing its GUI other than doing some sort of a script. But what helps to obtain the schema is the commands like SP_Help <table, stored procedure, etc name> this way you do not need to rely on SSMS GUI.Arthur My Blog

http://msdn.microsoft.com/en-us/library/ms187821.aspxSebastian Sajaroff Senior DBA Pharmacies Jean Coutu

http://msdn.microsoft.com/en-us/library/ms187821.aspx Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu Sebastian, this is for views only. On a separate note, can you drop me an email?Arthur My Blog

You're right. I've obviously misunderstood GisMaker063 request. Is there any way to send a private message through this forum?Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

No problem, sent you a message. Thank you for your help Cheers!Arthur My Blog