Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: script to drop tables

Re: script to drop tables

From: Michael Hill <l463520_at_lmtas.lmco.com>
Date: Fri, 09 Apr 1999 13:57:26 -0500
Message-ID: <370E4D96.2BB87A4E@lmtas.lmco.com>


The syntax is "drop table mytable" or to delete all the records in a table "delete * from mytable".

Does that answer your question?

Mike

Frans Hovenkamp wrote:

> Hi All,
>
> Of course I can figure it out when needed, but I wondered if there would be
> some tool that could provide me with a SQL/plus script to drop all the
> tables of a given application system in the right order?
>
> anybody out there who can tell me?
>
> Thanks in advance,
> Frans
Received on Fri Apr 09 1999 - 13:57:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US