Is "drop table" supported by SQL CE ?

  • Thread starter Thread starter nono
  • Start date Start date
N

nono

Hi,

I try to drop a table in the query analyser and receive
the following error :
"0x80040e14 DB_ERRORSINCOMMAND"
Native error (25501)
There was an error parsing the query ...

So, CE BOL says that "truncate" is a reserved word.

Thanks,
nono
 
There is a difference between "truncate" table and "drop"
table. "truncate" means that you want to delete all the
rows from the table without writing to a transaction log -
this is not supported in SQL CE. "DROP TABLE" is supported
as well as "DELETE FROM TABLE".

HTH... Alex
 
Sorry,
it was an error.
I would like to say :
Is "Truncate table" supported ..?
Anyway, you give me the answer, thanks !
nono
 
Back
Top