This article has been archived. It is offered "as is" and will no longer be updated.
Question: I am trying to create a new table in the Pervasive.SQL 2000 Control Center using the SQL Data Manager. I have selected my Dynamics database (which is working fine when I write select statements to view data in the Dynamics tables). I then use the following statement to create my table:
Answer: This error message is caused by having a semicolon in the SQL statement. The semicolon (;) will need to be removed from the SQL statement. Then you will be able to execute the statement and have it create the new Btrieve table.