<div>
I tried a select and it works fine.
</div>


<div>
I have also tried to modify field properties (changing type, deleting) and it comes up with the same error.<br />
If I add a field it works fine and doesnt complain. If I delete the new field it doesnt complain.<br />
Also the table has no data if that makes a difference.<br />
<br />
Any more ideas??
</div>


I have also tried to modify field properties (changing type, deleting) and it comes up with the same error.
If I add a field it works fine and doesnt complain. If I delete the new field it doesnt complain.
Also the table has no data if that makes a difference.

Any more ideas??

<div>
is this table involved in some sort of replication scenario?
</div>


is this table involved in some sort of replication scenario?

<div>
No, replication is not being used.
</div>


<div>
I found a solution.<br />
It seems the database was corrupt in some way.<br />
I downloaded and used the &quot;compact&quot; in this tool,<br />
&quot;SQLCE Database Viewer&quot; from <a href="http://www.pocketpctoolkit.com" rel="ugc">www.pocketpctoolkit.com</a>&nbsp;and it worked fine from then on.<br />
<br />
Thanks for your help QPR.
</div>


I found a solution.
It seems the database was corrupt in some way.
I downloaded and used the "compact" in this tool,
"SQLCE Database Viewer" from www.pocketpctoolkit.com [http://www.pocketpctoolkit.com] and it worked fine from then on.

Thanks for your help QPR.

<div>
<div class="content wysiwyg-content">
I am trying to drop a table in SQL Server Mobile Edition.<br />
I get the following error.<br />
&quot;No Key matching the described characteristics could be found within the current range&quot;<br />
<br />
Any idea how I get past this??
</div>
</div>


I am trying to drop a table in SQL Server Mobile Edition.
I get the following error.
"No Key matching the described characteristics could be found within the current range"

Any idea how I get past this??

Drop Table Error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.