SQL Command Reference

=======================
NETEZZA Create Table GUI
=======================

--------------------
A.) General Tab
--------------------
Table Name

Column Name 
Datatype
Length
Allow Nulls

Column

Default
COMMENT ON COLUMN table_name.column_name IS 'text';

--------------------
B.) Constraints Tab
--------------------

// Constraint on Table
      Name
      Type Drop Down
             [ PRIMARY KEY | FOREIGN KEY | UNIQUE ]
      
	  Ref Schema

      Ref table
 
// Constraint Definition
      Table Columns
	  Referenced Columns
	  
// Constraint Details 
Options for PRIMARY / UNIQUE / FOREIGN
      Deferrable  Drop Down
              [Yes | NO]
      Initially   Drop Down
              [None | Deferred | Immediate]

Options for FOREIGN KEY ONLY
      Match Type Drop Down
	           [ FULL | PARTIAL]
      ON UPDATE Drop Down  
	           [ CASCADE | RESTRICT | SET NULL | SET DEFAULT | NO ACTION ]
      ON DELETE Drop Down  
	           [ CASCADE | RESTRICT | SET NULL | SET DEFAULT | NO ACTION ]
			   
-------------------
C.) Storage Tab
-------------------
Temporary          [Yes | No]
DISTRIBUTE ON HASH [ Column Names] Note for Andy --> Same Behaviour as DB2 UDB Storage Tab and Dimension Columns Property
    Select Columns Dialog
	    Columns
		Selected Columns
		  ADD REMOVE
		  MOVE UP
		  MOVE DOWN
 
-------------------
d.) Comments Tab
-------------------

COMMENT ON [TABLE] object_name IS 'text'];

=====================================================
NETEZZA Create Table SYNTAX
=====================================================

CREATE [ TEMPORARY | TEMP ] TABLE table_name
  (
crea    column_name type [ [ constraint_name ] column_constraint [ constraint_characteristics ] ] [, ... ]
    [ [ constraint_name ] table_constraint [ constraint_characteristics ] ] [, ... ]
  ) [ DISTRIBUTE ON ( column [, ...] ) ] [ ROW SECURITY ]

  constraint_name can be:
  { CONSTRAINT name }

  column_constraint can be:
  { NOT NULL | NULL | UNIQUE | PRIMARY KEY | DEFAULT value |
    REFERENCES table [ ( column [, ... ] ) ]
      [ MATCH match_type ]
      [ ON UPDATE referential_action ]
      [ ON DELETE referential_action ]
  }

  table_constraint can be:
  { UNIQUE ( column_name [, ... ] ) |
    PRIMARY KEY ( column_name [, ... ] ) |
    FOREIGN KEY ( column_name [, ... ] )
      REFERENCES table [ ( column [, ... ] ) ]
        [ MATCH match_type ]
        [ ON UPDATE referential_action ]
        [ ON DELETE referential_action ]
  }
  match_type can be:
  { FULL | PARTIAL }

  referential_action can be:
  { CASCADE | RESTRICT | SET NULL | SET DEFAULT | NO ACTION }

  constraint_characteristics can be:
  { [ [ NOT ] DEFERRABLE ] { INITIALLY DEFERRED | INITIALLY IMMEDIATE } |
    [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [ NOT ] DEFERRABLE }

=======================
NETEZZA Create USER GUI
=======================

---------------
A.) General Tab
---------------

__ Name ________________________________________________________

   Name :           TextBox                 username
________________________________________________________________

__ Authentication ______________________________________________
       
   PASSWORD          TextBox                [ 'string' | NULL ]       
   SYSID             TextBox                 uid 
   ROWSETLIMIT       TextBox                 integer 
   VALID UNTIL       Date picker Dropdown    'date'           
   SESSIONTIMEOUT    TextBox                 integer 
   QUERYTIMEOUT      TextBox                 integer 
   DEFPRIORITY       Dropdown                [ CRITICAL | HIGH | NORMAL | LOW | NONE ] 
   MAXPRIORITY       Dropdowm                [ CRITICAL | HIGH | NORMAL | LOW | NONE ] 
   
   IN RESOURCEGROUP  Dropdown    resourcegroupname 
 
---------------
B.) Group Tab
---------------

   IN GROUP groupname [, ...]     Selection
   
---------------
C.) Preview SQL
---------------

=====================================================
NETEZZA Create User SYNTAX
=====================================================
CREATE USER username
[WITH
[PASSWORD {'string' | NULL }]
[SYSID uid]
[ROWSETLIMIT [integer ]
[IN GROUP groupname [, ...] ]
[VALID UNTIL 'date' ]
[SESSIONTIMEOUT [integer ]
[QUERYTIMEOUT [integer ]
[DEFPRIORITY [critical|high|normal|low|none]]
[MAXPRIORITY [critical|high|normal|low|none]]
[IN RESOURCEGROUP resourcegroupname]
]

=======================
NETEZZA Create Group GUI
=======================

---------------
A.) General Tab
---------------

__ Name ________________________________________________

   Name :                    TextBox      Groupame
________________________________________________________

__ Settings ____________________________________________
       
   SYSID                     TextBox     gid 
   ROWSET LIMIT              TextBox     integer 
   SESSION IDLE TIMEOUT      TextBox     integer 
   QUERY TIMEOUT             TextBox     integer 
   DEFAULT PRIORITY          Dropdown    [ CRITICAL | HIGH | NORMAL | LOW | NONE ] 
   MAXIMUM PRIORITY          Dropdown    [ CRITICAL | HIGH | NORMAL | LOW | NONE ] 
   Resource Allocation       TextBox     resourcepercent 
 
---------------
B.) User Tab
---------------

__ User Members  _________________________________________

   IN USER username [, ...]     Selection
   
---------------
C.) Preview SQL
---------------