Deleting Tables From Maser DB

[xlu21]

First Question.
To copy a database, will import data be the same as copy.

Second Question.
I did a data import from a database but I orverlooked at the step that asks you where you want to import to.
So it import all my tables into the master database.
Is there a way to delete those tables with out doind it one by one? There are over 500 tables...

 

[ptheriault]

For your first question the answer is yes.

For your second. What version of SQL is it. I would create script that creates a drop script.

something like this.

select distinct 'DROP TABLE '+table_name
from master.information_schema.columns

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

I should also mention that from within SSMS you can highlight all the tables you want to drop and select delete.

- Paul
- If at first you don't succeed, find out if the loser gets anything.