How to force explicit schema for created objects?
Is it possible to force create statements to require an explicit schema?
When we deploy new applications, we run scripts to create tables and such in appropriate the appropriate schema. Since we always connect as ourselves, I want to minimize the possibility that I forget to put the schema and accidentally create the object in my own schema. I really don't want to have to connect as a different user, or rely on changing the current schema in login.sql or a logon trigger.
Thanks,
Matt Knowles