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 quotes (that is, preserving the lettercase).
If you create a database object without explicitly specifying an owner name in a database that is ANSI-compliant, your authorization identifier (as the default owner of the object) is 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.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]