Re: truncate tables in my tablespace
Date: Fri, 18 Jan 2008 03:07:25 -0800 (PST)
On 18 Jan, 10:53, burrell.j..._at_yahoo.com wrote:
> Thanks you all for the very thorough answers- One question remains
> tho. My intention is the thro all the data away so would delete from
> tablename have the same restriction with constraints as truncate?
> J- Hide quoted text -
> - Show quoted text -
Yes, DELETE will also have issues with foreign keys. Plus, TRUNCATE will be faster.
HTH -g Received on Fri Jan 18 2008 - 05:07:25 CST