Search code examples
sqlsql-server-ceddldrop-tablequery-analyzer

Why is my SQL Server CE table undroppable in Query Analzyer?

I tried dropping a SQL Server CE table using both:

drop invHeader

-and:

drop [invHeader]

...in Query Analyzer, but in both cases, I get the same err msg:

enter image description here

Dropping a table should be drop-dead easy, but this one keeps bouncing back up, like a reverse Humpty Dumpty.

What do I need to do to drop it hard enough for it to really go away - "Nuke invHeader"?

To add insult to injury, after this command failed (both "styles" of designating the table name), Query Analyzer seems to lose its synaptic connections and won't allow me to edit the SQL/DDL statement any longer - I have to warm boot the handheld device before it comes to its synapses again.

Solution

  • Your syntax is incorrect - in order to drop a table you should use

    DROP TABLE invHeader;