I wanted to write CREATE TABLE command so that all the files in a folder can be recreated with that command. The files are free dbf tables.
But from Anders answer, I came to know about gendbc and it could be done.

Thanks to you also.

> > 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.
>
> I am sorry, but I do not understand what you are trying to do here. Where are these tables? What are you trying to do with them?
>
> If these are VFP Tables you cannot "drop them" into SQL Server, but there is an Upsizing Wizard that will take your VFP tables and generate the erquivalent tables in SQL Server.
>
> If they are in SQL Server then you can generate the "Create" script in Management Sudio (SQL 2005/2008) by right clicking on the table in the object explorer view and choosing the "Script Table As" option.
>
> If this does not help, can you be a little more specific as to what you are doing, please?
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Tightline Computers Inc, Akron Ohio, USA