Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2000 @ 10:48:28 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016