Default Schema

The Default Schema field in the New Connection Information window indicates the schema name used for the current user.

You must set a value in the Default Schema field for some databases if the database user name and the default schema specified in the database are different:

  • If you set the value of the Default Schema field to the same as the default schema specified in an Oracle database or leave the Default Schema field empty for an Oracle database, the table you select in the adapter service Schema tab is loaded from the default schema and the publishing table is also generated in the default schema.
  • If you set the value of the Default Schema field to the same as the default schema specified in an Oracle database, and select a table from a different schema (other schema) than the default schema by clicking Add From Other Schema in the Table Download Dialog window, the table you select in the Schema tab is loaded from the other schema but the publishing table is generated in the default schema. If you want the publishing table to be generated in the other schema, you must prefix the publishing table name with the other schema name in the Publication Options tab.
  • If you set the value of the Default Schema field to a different schema (other schema) name than the default schema specified in an Oracle database, and select a table from the other schema by clicking Add From Other Schema in the Table Download Dialog window, the table you select in the Schema tab is loaded from the other schema and the publishing table is also generated in the other schema.
  • If you set the value of the Default Schema field to DBO for a Microsoft SQL Server database or Public for a PostgreSQL database, the DBO schema or Public schema is used as the default schema. The table you select in the adapter service Schema tab is loaded from the default schema, and the publishing table is also generated in the default schema.
  • If you set the default schema to a non-DBO schema (other schema) for a Microsoft SQL Server database or a non-Public schema (other schema) for a PostgreSQL database, and select a table from the other schema by clicking Add From Other Schema in the Table Download Dialog window, the table you select in the Schema tab is loaded from the other schema and the publishing table is also generated in the other schema.