> 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