How to get the DDL to create some tables?

[mm8294]

We have an Informix database and the boss want me to get the script to create 90 existing tables. He does not really want to recreate those existing tables, but he want the DDL script. Does anybody know how to do it in Informix? Don't tell me I have no alternative but doing it manually.

Thanks a lot.

 

[mm8294]

By the way, the boss want the commands to grant the privileges on those tables (such as 'GRANT select ON table_name to User_name) be included in the file. I don't know if this is possible.

Thanks.

 

[Guest_imported]

MM8294:

Informix has the dbschema utility that creates the schema for a single table or the whole database:

dbschema -t all -d <dbname> -p all <outputfilename>

This does the whole database, but if all your table names are in tmpfile:

while read file
do
dbschema -t $file -d <dbname -p all &quot;$file&quot;.sql
done < tmpfile

Regards,


Ed
Schaefer

 

[mm8294]

Thanks a lot. This is what I need.