Start a new topic

Export Schema SQL Qualify Name

Is there any better documentation or a reference on how to use the Qualify name option when exporting a schema to SQL? I would like to export a subset of tables and I am guessing that this would be a way to do that.

1 Comment

Hi,


If you enable Qualify Name, the specified name is used to qualify the object names in the generated SQL statements, e.g. with FOO as the qualifier and a table named BAR, the INSERT statement is generated like this:


INSERT INTO FOO.BAR ...


If you want to export just a subset of tables, select only the tables you want to export in the Object Types tree.


Best Regards,

Hans

Login or Signup to post a comment