TRUNCATE and OleDbCommand

[onepieceking]

Hi,

Just to check. Is "TRUNCATE" usable in OleDbCommand?

I am getting an error of invalid SQL statement when i execute this code

Dim deletestr as string
deletestr = "TRUNCATE TABLE [" + TableName + "]"
Dim myCommand as OleDbCommand
myCommand = New OleDbCommand(deletestr, myconn)
myCommand.ExecuteNonQuery()