P Kishor uttered:
looking at the SQL supported by SQLite, I see no mention of TRUNCATE.
Not in the SQL clauses supported, nor in the clauses omitted. Is
TRUNCATE a weird beast?
I don't think it's standard SQL. At least not SQL92 that SQLite aims to
implement.
TRUNCATE is an optimised version of DELETE for tables, which dispenses
with deleting row by row. SQLite already optimises this case anyway, by
DROPping a table and recreating it when a DELETE with no WHERE clause is
executed.
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
