-- Truncate Table --

[r9ronaldo]

Hi All,
This maybe a Basic Question. I am using WINSQL as a client to query a Redbrcik Database.
Somehow when I use the following command.
truncate table A
it gives me a syntax error
I was able to do it with comman
delete from A

I just want to know what is the problem with the syntax truncate table A

Thanks in Advance
R9

 

[sem]

I know nothing about WINSQL and Redbrcik Database, but may assume that this tool executes only DML/QUERIES, while TRUNCATE is DDL command.


Regards, Dima