Gossamer Forum
Home : General : Databases and SQL :

dropping tables

Quote Reply
dropping tables
Hi,

I would like to drop a large number of tables in a database. Is there a way of selecting them from a list in enterprise manager or do I have to type the syntax for each table I want to drop? I'm using SQL Server 2000. Thanks.

Last edited by:

Dagk: Oct 22, 2003, 8:04 AM
Quote Reply
Re: [Dagk] dropping tables In reply to
Right click on the table....
Click Delete

Voila!

Although what I typically do is write a SQL script that can be used both in the local development and remote production SQL Servers...

Example:

DELETE TABLE tablename;
DELETE TABLE tablename;

Rather than having to connect to the remote server via Enterprise Manager, which is a resource hog, I use Query Analyzer to update or delete tables in my local DEV and remote PROD environments.

Might want to check out the SQL site at M$ for information and turorials:

http://www.microsoft.com/sql/
========================================
Buh Bye!

Cheers,
Me