Create New Table from existing table

[shangrilla]

Hi:

I need to create a new table that has the same structure as an existing table.

For eg: c:\myApp\SalesMan.dbf (this already exists)

I need to create c:\test\SalesMan.dbf (this should have the same structure as c:\myApp\SalesMan.dbf)

Thanks in advance

 

[robsuttonjr]

IF !USED('c:\myApp\SalesMan.dbf')
USER 'c:\myApp\SalesMan.dbf' IN 0
ENDIF
SELECT SalesMan

** This line copies structure and data
COPY TO c:\test\SalesMan.dbf

** This line copies structure only
COPY STRUCTURE TO c:\test\SalesMan.dbf

 

[robsuttonjr]

Sorry, typo in 2 line of code:
IF !USED('c:\myApp\SalesMan.dbf')
USE 'c:\myApp\SalesMan.dbf' IN 0
ENDIF

 

[robsuttonjr]

Take 3, Sorry, typo in 2 line of code:
IF !USED('c:\myApp\SalesMan.dbf')
USE c:\myApp\SalesMan.dbf IN 0
ENDIF

 

[FoxCoder]

********************************************
* Create with Same Structure - No Data


SELECT 0
USE c:\myApp\SalesMan NOUPDATE
=AFIELDS(arTemp)
CREATE TABLE c:\test\SalesMan FROM ARRAY arTemp
RELEASE arTemp

**Note you can also create cursors this way if your test **table is for a temporary purpose