 |
 |
Archives of the TeradataForum
Message Posted: Thu, 22 Jun 2000 @ 10:48:28 GMT
| Subj: | | Re: Dropping non-existent tables! |
| |
| From: | | Julie Sorrell |
| | Assuming the tables are the only ones in the database, entering 'Delete Database XXX' should get rid of them.(You will need drop
database privilege for this). | |
Unfortunately, they're not the only ones in the database by a long shot.
| | If the tables aren't the only objects in the database, you would need to copy any that you want to keep to another location
first, before doing the delete. | |
Yikes - that is *not* going to be a small job for this database. Thanks, Mark, but I think that's going to be a last resort solution. I
would definitely try to restore the tables again from tape before I considered this.
Cheers,
--
Julie Sorrell
| |
