delete tables in sqlserver

[Lee Taylor-Vaughan]

Hello,

I have been playing around with SQL server; i installed it from MSDE off the
office CD.

I have tested upsizing databases and stuff, just to see what it is like.
now, how do i delete all the stuff (such as tables on the sql server). I can
delete them all in the container window, but when i want to link to other
databases, i can still see them in the dropdown list (how do i remove them?)

thanks

Lee

 

[Peter Wone]

There are two ways to upsize a Jet database application to a SQL Server.

Both ways create a SQL Server database and containing tables corresponding
to the original MDB.

One way links all the SS tables to a Jet database (MDB file).

The other way creates an ADP which essentially uses the SQL Server directly
instead of Jet.

With the first type, if you delete the linked tables you are simply deleting
the links, not the tables - as you describe.

With the second type, when you delete a table you really are deleting a
table.

So you could create a Project (existing data) and then delete all the tables
from it. Then you'd have a SQL Server database with no tables in it.

Or you could use Query Analyser. This is a SQL Server client application and
I have no idea whether Microsoft supplies it with MSDE. But if you have it,
you can type DROP DATABASE MyDatabaseName and get rid of the whole lot in
one go.