Disable multiple schema support

You can disable support by changing the enable_schema_dbo_check variable and restarting the software.

Following the steps in Enable multiple schema support, change the value of the enable_schema_dbo_check variable to 0 and restart the Netezza Performance Server software. Use caution when you disable the multiple schema support, because the schemas still exist in the databases but users cannot create, alter, drop, or use the SET SCHEMA command to change to any schemas that are not the database default schema. Users can still reference the schemas in object names within their queries.