I need alter the table to include Identity column. ALTER TABLE MGMT_RPT ADD USER_ID INT IDENTITY(1, 1) AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (USER_ID) And ALTER TABLE MGMT_RPT ADD USER_ID SEQUENCE(MAX,1) NOT NULL, ADD PRIMARY KEY (USER_ID) I am getting error ORA-01735 in both cases. Please help. Thank you.
Could you try adding the primary key as a separate ALTER (I have no idea how Oracle is different from SSMS so this may well be wrong) ALTER TABLE TEST ADD USER_ID INT IDENTITY(1,1) NOT NULL ALTER TABLE TEST ADD PRIMARY KEY (user_id)