Thanks. I got it from your code.
> > Hi Experts,
> >
> > There are about 40 files. I have created them using CREATE
command. I want to create all the files using CREATE TABLE command. In SQL Server, it is possible to get CREATE TABLE command by dropping table in the command area. Do we have anything like that ?
> >
> > Or I will have to look at the structure of all the files and construct CREATE TABLE command.
> >
> > Thanks all.
>
>
> If the tables are attached to a VFP database you can
> DO GENDBC.PRG
(it's in a HOME() folder) and it will generate a complete program script to rebuild your system in all its details.
> If they are all "free" tables, now is the time to this:
> CREATE DATABASE Data\MyData
> OPEN DATABASE ?
> SET DATABASE TO Mydata
> ADD TABLE xx NAME whateveryouwant
>
>
You can also do this in the Program Manager by clicking the buttons on the Data page,
> or in the Database Designer:
> MODIFY DATABASE
>
-Anders