Hi, I am using a trigger to insert a row into a backup table when a row is created in the actual table. Both tables have identity column and i am not using the idcolumn in the trigger. REPLACE TRIGGER trigger name AFTER INSERT ON table REFERENCING NEW AS new_rec FOR EACH ROW ( INS backup_table ( col1,col2,col3) VALUES (col1,col2,col3); ) ; I tried changing the backup table to generated by always and tried but still doesnt work. The id column is the primary index column. We get this error -INSERT Failed. 5784: Illegal usage of Identity Column . any suggestion?? Thanks, Priti
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.