Does anyone know if the widely supported TRUNCATE TABLE statement is
actually ANSI/ISO standard SQL? A quick Google didn't answer this for
me, but I'm not very patient with Google searches.

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.

On Feb 22, 2009, at 8:59 AM, Roy Hann wrote:

I don't believe it is. I searched a draft PDF of SQL Foundation,
from a couple years ago, and it's not in there.

Karl

Hi Roy,

It is has been published in ISO/IEC 9075-2:2008.

Ray

On 22 Feb, 13:59, Roy Hann <specia... (AT) processed (DOT) almost.meat> wrote:

Thanks Ray. So it's a recent addition to the standard. That explains
why none of my rather stale references mention it.

Roy

withdefault (AT) gmail (DOT) com wrote:

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.