The temporary table can have the same name as a permanent table.
The temporary table is created in a separate, session-specific schema.
You can use the DISTKEY keyword after a column name or as part of the table definition by using the DISTKEY ( Keyword that specifies that the column is the sort key for the table.The expression is used in any INSERT operation that does not specify a value for the column.If no default value is specified, the default value for the column is null.When data is loaded into the table, the data is sorted by one or more columns that are designated as sort keys.You can use the SORTKEY keyword after a column name to specify a single-column sort key, or you can specify one or more columns as sort key columns for the table by using the SORTKEY ( Keyword that specifies that the column can contain only unique values.
Note If you are creating a "wide table," take care that your list of columns does not exceed row-width boundaries for intermediate results during loads and query processing. MAX sets the maximum length to 4096 bytes for CHAR or 65535 bytes for VARCHAR.