Use SQL to create files from existing DDFs

[kerryn]

I have an application using Pervasive 2000i where I have the DDF's built and I access the Pervasive data using ODBC. I don't want to have to include "empty" MKD files with the installation. I want to only include the DDF files and then use code to create the pyhsical files (i.e. *.mkd files) as needed. Is there a way, using SQL commands, to create the actual files from the table definitions in an existing DDF set? I know that the CREATE TABLE USING command will do this, but only if the table does not already exist.

Thanks in advance,
Kerry

 

[TomKane]

I f you drop the table first that will delete the physical file also...