Re: Empty a table..

From: <jasonkatz_at_hotmail.com>
Date: 28 Aug 98 21:12:12 GMT
Message-ID: <35e71d2c.0@olson.gtdev.com>

"Colin" <colin_at_flash.a2000.nl> wrote:
>What is the fastest way to empty a table with SQL (I do not mean the easiest
>way !).. I have an Oracle 7.x database.
>

Colin,

The simplest and cleanest way of doing this is to isuue a delete command against the table; ie: DELETE TABLE TABLE_NAME. This will only delete the data from the table. All of the structures and relationships will still exist.

Jason

Received on Fri Aug 28 1998 - 16:12:12 CDT

This message: [ Message body ]
Next message: Yoni: "Using ActiveX in Forms 5.0"
Previous message: Arjan van Bentem: "Re: newbie question about rownum"
In reply to: Colin: "Empty a table.."
Next in thread: Colin: "Re: Empty a table.."
Reply: Colin: "Re: Empty a table.."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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