Default Owner Names

If you create a database object without explicitly specifying an owner name in a database that is not ANSI-compliant, your authorization identifier (as the default owner of the object) is stored in the system catalog of the database as if you had specified your authorization identifier within quotation marks (that is, preserving the lettercase).

If you create a database object without explicitly specifying an owner name in a database that is ANSI-compliant, any lowercase letters in your authorization identifier (as the default owner of the object) are stored in the system catalog of the database in uppercase characters, unless the ANSIOWNER environment variable was set to 1 before the database server was initialized. If ANSIOWNER was set to 1, however, the database stores the default owner of the object as your authorization identifier, with its lettercase preserved.