Re: How Convert the schema of a table to a Ascci File .SQL

In article <64r2kg$cu0_at_dfw-ixnews7.ix.netcom.com>, Boroskie <boroskie_at_ix.netcom.com> writes
>Export the user will all options with rows / table data no. The
>resulting dmp file( ASCII editable) will have all the SQL to create
>tables, indexes....
>
>Best of luck, Boroskie(boroskie_at_ix.netcom.com)

Hey!

Let's make this a little easier!

Having created your export file (without data), import it and use the indexfile option - this will create a complete SQL file corresponding to the export file. In this form only the index creation statements are uncommented, but it's a simple task to remove the REMs surrounding the table creation statements.

Andy
>
>
>In article <01bcf47f$93123840$d6c57ac3_at_xsm>, m5219_at_hotmail.com says...
>>
>>How i can convert the schema of a table or user with the format:
>>
>>
>>create table customers .................
>>
>>
>>
>>create index ..................
>>
>>
>>In Informix : dbschema -d <database> -t <tabla>
>>this command generate a .SQL that content the sql instruction to create
 the
>>table.
>>Thanks and regard from spain.
>>
>>
>>m5219_at_hotmail.com
>
 

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG