Very Computer

> I am writing a program in Visual Basic, and I need to run some kind of
> a script via ODBC. I want SQLServer to tell me the table structure.
> Can this be done?

> I basically want returned the script which you can run in Enterprise
> Manager. I will be using the returned data to build a Create Table
> clause. I will not know the table structure before hand, so I need
> something SQLServer to return something like:

> CREATE TABLE Customer (
> CustID varchar (255) NOT NULL ,
> FName varchar (40) NOT NULL ,
> MName varchar (40) NULL ,
> LName varchar (40) NOT NULL ,
> Title varchar (5) NOT NULL ,
> Email varchar (30) NULL ,
> Address varchar (255) NOT NULL
>               )

> Thanks in advance for any help!!

> Jeff

> > Hello,

> > I am writing a program in Visual Basic, and I need to run some kind
of
> > a script via ODBC. I want SQLServer to tell me the table structure.
> > Can this be done?

> > I basically want returned the script which you can run in Enterprise
> > Manager. I will be using the returned data to build a Create Table
> > clause. I will not know the table structure before hand, so I need
> > something SQLServer to return something like:

> > CREATE TABLE Customer (
> > CustID varchar (255) NOT NULL ,
> > FName varchar (40) NOT NULL ,
> > MName varchar (40) NULL ,
> > LName varchar (40) NOT NULL ,
> > Title varchar (5) NOT NULL ,
> > Email varchar (30) NULL ,
> > Address varchar (255) NOT NULL
> >               )

> > Thanks in advance for any help!!

> > Jeff