Hi,

Does anyone know of any script or function that can extract a table
definition from another data server?

I am bcp'ing out the data from another data server and intend to move
this data to my data server. Hence i require the table definition. I
do not wish to "hard code" but want to create a new temporary table
dynamically (since the table structure may change).

Therefore i am in need of a script that i could run using isql or sqsh
to generate another table of the same structure.

Thanks,
Fahd

PS: Not defncopy!

In article <9bc0209f.0308160131.2d945e39@posting.google.com >, Fahd Shariff wrote:
> Hi,
>
> Does anyone know of any script or function that can extract a table
> definition from another data server?
>
> I am bcp'ing out the data from another data server and intend to move
> this data to my data server. Hence i require the table definition. I
> do not wish to "hard code" but want to create a new temporary table
> dynamically (since the table structure may change).
>
> Therefore i am in need of a script that i could run using isql or sqsh
> to generate another table of the same structure.
>
> Thanks,
> Fahd
>
> PS: Not defncopy!

dbschema (http://www.midsomer.org/#dbschema.pl); needs Perl or
ddlgen (http://www.sypron.nl/ddlgen.html) in ASE 12.5; needs Java

--
___ _
| _ \___ _ _ ___//
| / -_) ' \/ -_)
|_|_\___|_||_\___|