SQL - syntax error in DELETE ALL FROM statement

8 Aug 2013

      Hi,
It is me again. :(
I'm trying to "truncate" according to 
http://www.monetdb.org/Documentation/SQLreference/Updates using DELETE 
ALL FROM statement. But what I get is syntax error. :(

ceos@lux-analytics:~$ mclient -h localhost -d zkdev1 -u drmaxtst -p 50000
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013-SP3)
Database: MonetDB v11.15.11 (Feb2013-SP3), 
'mapi:monetdb://lux-analytics:50000/zkdev1'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>delete all from crmkarta;
syntax error, unexpected ALL, expecting FROM in: "delete all"
sql>

Thank you for any hints.
Best regards,
Radovan

-- 
__________________________

Radovan Bičiště