perhaps I am misunderstanding what you are asking but after creating a table you need to right click the database in the object explorer and hit refresh.
A dropdown on the toolbar when you are writing a query shows the currently selected database
>It is definitly taking some getting used to.
>
>I just ran this SQL:
>
>
>
>IF OBJECT_ID ('Clients') IS NOT NULL
> BEGIN
> DROP TABLE Clients
> END
>
>CREATE TABLE Clients
> (Rec_Id INTEGER IDENTITY PRIMARY KEY NOT NULL,
> ClientName VARCHAR(40) NOT NULL)
>
>
>>
>Yes, I do not see the table listed in the object explorer. Where is my table?
>
>And, how do I ensure that the table is being created in the correct database?
>
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
