SQL COMPACT - Ceate Table

I am using Visual Studio 2005 (with the Windows Mobile extensions); SQL Compact. This is on a Vista machine. I am new to this environment.

-- I am struggling with the interface to SQL Compact from within VS 2005 (VB code). Specifically, if I try to run a "CREAT TABLE ...." command from code it appears to complete, but the table is not created.



I am using a sample create table SQL statement from a Microsoft web page:



'CREATE TABLE MyCustomers (CustID int IDENTITY (100,1) PRIMARY KEY, CompanyName nvarchar (50))'

-- its the one that fails with warning message:

"The CREATE TABLE SQL construct or statement is not supported. "

The above is in a window titled "Query Defninitions Differ" and a note at the bottom of the window:

"The Query cannot be represented graphically in the Diagram and Criteria pane."

After the warning message, the table is created -- but not in VB code. There I get no warning and no table.


Your help is appreciated.