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

ppp wrote:
>
> 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

Hi,

I think the easiset way is to export the user you want to copy from.

Then create the new user(s) with the 'connect' role as default. Remember to specify default table space for the new user(s). The next step is to import the exported user into the new user. If you want to copy the scheme to several user I think you've to make the last step several times. I never tested it.

-- 
Regards

Matthias Gresz    :-)