Re: TRUNCATE TABLE?

Obnoxio, Yep, that's how we decided to do it. Do the minute but significant differences between DBMSs seem bizarre and hideously annoying to anyone else? We're doing development in Image (HP3000/MPE), Oracle (Unix and NT, 7.3 and 8), Informix (for two customers on UNIX), Access (for the ODBC client), and now SQL server. Grrrr! At 11:42 AM +0000 6/30/99, Obnoxio The Clown wrote: >From: justfred@home.com >> >>Is there a fast and simple way to do a TRUNCATE TABLE? >> >>DELETE * FROM table_name takes a lot longer than TRUNCATE TABLE (from >>Oracle). > >Drop the table and recreate it? > >>"I am Barney of Borg. I love you, you love me. Resistance is futile." > >:-))))))) > > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com Fred Heald justfred@netcom.com justfred@sideshowfreak.com ------------------------------------------------------------------------------ Light a man a fire, and he'll be warm for a night; light a man ON fire and he'll be warm for the rest of his life. ------------------------------------------------------------------------------ www.prosperopublishing.com/~justfred