| Database schema / Database schema extractor options | |
With some databases, the owner of tables is mandatory to extract a schema, otherwise you could get multiple definitions of the same table in the .sch schema file if tables with the same name exist in different database user schemas. To prevent such mistakes, you can specify the schema owner with the -ow owner option. If this option is not used, fgldbsch will use the database login name passed with the -un user option. This is usually the case with SQL Server and Sybase, where the owner of tables is "dbo".
fgldbsch -db test1 -un scott -up fourjs -ow dbo