![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
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
| |