CREATE TABLE OrderItems
(
  order_num  int          NOT NULL ,
  order_item int          NOT NULL ,
  prod_id    char(10)     NOT NULL ,
  quantity   int          NOT NULL ,
  item_price decimal(8,2) NOT NULL 
); 

quote:

---

Originally posted by peterhw

I am new to SQL and using SQL Server 2012 Studio.
I am also generating VBA code in EXCEL to run with SQL.

I created a new database called Test by right clicking on Databases and add new one. Similarly I created a new table. No problem all worked fine. I can see a database called Test and my new table.

If I run

CREATE TABLE OrderItems
(
  order_num  int          NOT NULL ,
  order_item int          NOT NULL ,
  prod_id    char(10)     NOT NULL ,
  quantity   int          NOT NULL ,
  item_price decimal(8,2) NOT NULL 
); 

It Executes but I can't find the Table.
I have now used the USE command to create in a specified database and that works but I still can't find the first table created. I can't find a Tables section (other than my Test database)

---

EXEC sp_Msforeachdb 'IF EXISTS(SELECT 1 FROM ?.INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = ''OrderItems'') SELECT ''?'''

quote:

---

Originally posted by peterhw

Thanks

Yes - that appears to list them but no still idea where to find them.

It doesn't really matter but I created these very early on and i9n practice I should have created in a new database 'Order_Processing' or similar and I would like to delete the originals

---

quote:

---

just expand system databases master and expand tables folder within them to find required tables

---

quote:

---

Originally posted by jackv

If you can view them via the SELECT statement - then you can issue a DROP TABLE command. Assuming you have the permissions

---

   '''; DROP DATABASE Problems; -- '

quote:

---

Originally posted by Transact Charlie

ssms = sql server management studio.

---

quote:

---

Sometimes when you create a new table the GUI doesn't refresh. You can right click on the db or the tables folder in the db and click on refresh.

---

quote:

---

Also you should see a toolbar on the top of SSMS by default that shows you which db you are running commands in.

Stay out of master.

---