Gossamer Forum
Home : General : Databases and SQL :

Re: [Dagk] dropping tables

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
Subject Author Views Date
Thread dropping tables Dagk 3818 Oct 22, 2003, 7:26 AM
Post Re: [Dagk] dropping tables
Stealth 3612 Oct 22, 2003, 10:48 AM