InstanceEnvironment Table

InstanceEnvironment is a static table listing the possible environments in which database instances may be deployed. For some vendors, the environment affects the costs of licensing the database instance.

Table 1. Database columns for InstanceEnvironment table

Database Column



Type: integer. Key. Generated ID

A unique identifier for an InstanceEnvironment. Possible values and the corresponding default names are:

  • 1 = Development
  • 2 = Test
  • 3 = Staging
  • 4 = Production
  • 5 = Other.

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an instance environment. Foreign key to the ComplianceResourceString table.


Type: text (max 100 characters)

The text to display if the environment resource string has no translation.