Official Content

Forces all Model programs (Creation/Reorganization programs and Application programs) to point to a specific SCHEMA.

Values

Specified the schema name.

How to apply changes

Rebuild all objects

Description

Some of the DBMSs (Oracle, DB2) accept that database objects be qualified with respect to a "SCHEMA". This means that two different objects with the same name are able to exist because they belong to different SCHEMAS.
An application which makes use of this facility is when different schemas are being implemented for each different version of the application (Development, Test and Production), but all of them are defined over the same database.

Notes:

  • This is strictly necessary for some DBMSs working over some platforms that only allow the use of one Database (Oracle-NetWare).
     
  • In SQLServer Database Manager this property referred to the user.

Scope

Languages: .Net, Java, Visual FoxPro (up to GeneXus X Evolution 3)
DBMS: SQL Server, Oracle, Informix, PostgreSQL

See Also

Database name property







Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant