We are trying to reduce the space taken up by the database for our accounting system. We were told by their tech support which tables are temporary and can be deleted. How do I delete a table in SQL? Do I right click and choose "delete"?
Also, I went into SQL, clicked on the database name and then on the tables folder but I did not see any tables that matched the names given to us by tech support. Any ideas on why they would not be there? Could SQl be deleting them automatically?