Copy Table

[celeron895]

In MS SQL Server you use this statement:

SELECT * INTO MYTABLECOPY FROM MYTABLE

Is there an equivalent statement in Pervasive 7.0?

 

[mirtheil]

No. There is no direct equivalent statement. You could probably a select as a subquery for an insert like:
insert into table (select * from oldtable). You'll need to look up the exact syntax since 7.0 is an older product and I don't use it anymore.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[celeron895]

My problem is, the table isn't even created yet. How do I create a copy of an existing table? There is a table MyTable, and I want an exact copy of the structure (MyTableCopy). I am not worried about the data.