What version of Pervasive.SQL are you using? If you want to use a Pervasive tool you would use:
With V7, you would use SQL Scope or DDF Ease.
With PSQL 2000, you would use the Pervasive Control Center and the Create Table Wizard.
WIth PSQL V8 or V9, you could use the PCC and Create Table Wizard or a CREATE TABLE with the IN DICTIONARY clause.
There are several other third party DDF utilities as well.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
I have downloaded pvquery and I am looking at it. The program, I am writing, is a dataflex program so I don't think I can execute an sql statement in it as it uses a connectivity kit to connect to Pervasive.
I was sort of looking for something that clones a table from one set of ddfs to another like butil -clone but I guess I shall have to create the table.