Netezza Database Schema: CREATE, ALTER, DROP and SET SCHEMA
In the previous version, the Netezza system supported one default schema per database. You can configure multiple schema within database in latest release. In this article, we will check on Netezza database schema and how to create, alter, drop and set schema for Netezza database. In the latest release, Netezza system can validate the schema information i.e. you can configure the system to return an error for any queries that specify an invalid or non-existent schema, or you can configure the system to return a warning message for queries that…