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
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