CREATE TABLE

Use the CREATE TABLE command to create a table with the option of row security support.

Synopsis

Syntax for creating a table:

CREATE TABLE <table-name> ( <element-list> )
[ DISTRIBUTE ON { RANDOM | [HASH] ( <distribution-list> ) } ]
   [ ROW SECURITY ]

Inputs

The CREATE TABLE command has the following input:

Table 1. CREATE TABLE input
Input	Description
ROW SECURITY	Create a table with row-level security.

Outputs

There is no changed output.

Description

For details about all the options of the CREATE TABLE command, see theIBM® Netezza® Database User’s Guide. The CREATE TABLE command has the following characteristics:

Privileges required: You must have CREATE TABLE privilege to create a table. No additional privilege is required to create a table with row-level security.
Common tasks: Use the CREATE TABLE command to create a table with the option of row security support.

Usage

The following provides sample usage:

CREATE TABLE NEWTABLE DISTRIBUTE ON RANDOM ROW SECURITY;