Netezza Create Table Command and Examples

Use the Netezza CREATE TABLE command to create a new, initially empty table in the current database. The CREATE TABLE command automatically creates a data type that represents the tuple type (structure type) corresponding to one row of the table. Netezza Create Table Command Syntax CREATE [ TEMPORARY | TEMP ] TABLE <table> ( <col> <type> [<col_constraint>][,<col> <type> [<col_constraint>]…] [<table_constraint>[,<table_constraint>… ] ) [ DISTRIBUTE ON { RANDOM | [HASH] (<col>[,<col>…]) } ] [ ORGANIZE ON { (<col>) | NONE } ] [ ROW SECURITY ] Read: Importance of right Distribution…

Continue ReadingNetezza Create Table Command and Examples
Comments Off on Netezza Create Table Command and Examples

Netezza Temporary Tables and Examples

Like any other database, Netezza also supports temp or temporary tables. There are three types of Netezza temporary tables; all of them have advantage over traditional temporary tables. Netezza Temporary Tables Netezza temporary tables are local to the user session. You can use temporary table repeatedly within a user session for multiple times. Like derived tables, temporary tables also use Netezza swap partition space. You can drop and recreate the temporary table within the user session. However, these temporary tables are not visible outside the user session. You do not…

Continue ReadingNetezza Temporary Tables and Examples
Comments Off on Netezza Temporary Tables and Examples