Kevin,

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?










>I found it. Thanks!
>
>Glad you found it.
>
>Management Studio takes some getting used to, but in the end you should like it.
>
>By the way, if you want a nice overview of all the new features in SQL 2005, you might want to check this out: (author is the technical editor for SQL Server Magazine)
>
>http://www.amazon.com/gp/product/0072227761/sr=1-9/qid=1153722872/ref=sr_1_9/104-6217512-7451143?ie=UTF8&s=books
>
>Kevin