When viewing the script for a table in a Vertica database, an IDENTITY column is being scripted as INTEGER NOT NULL.
Example:
1. CREATE TABLE TEST001(
ID IDENTITY(1,1),
C_1 VARCHAR(25))
2. After creating, go to View Details of the table TEST001, the generated script is not correct as below.
CREATE TABLE TEST001
(
ID INTEGER NOT NULL,
C_1 VARCHAR (25)
)
