I am new to SQL and am trying to either change the extension of an existing table in a pervasive database or copy the table to a new table.
When I added the table, I assumed Pervasive would use the same extension as the rest of the tables, '.DAT'. It defaulted to '.MKD'. For consistency, I want to end up with my new table having the '.DAT' extension.
I tried the following, unsuccessfully, to make a duplicate table with the correct extension:
sql = "SELECT * INTO TableName USING 'TableName.dat' FROM TableName"
sql = "CREATE TABLE TableName USING 'TableName.dat' SELECT * FROM TableName"
(I doubt it would have worked even if Pervasive had recognized the USING keyword because of the redundant table names.)
Is there a way to just rename the existing table and update the DDF and INDEX tables?
Otherwise my next plan is to create the new empty table properly with the USING keyword, and then copying all the records to the new table.