Hi, I am trying to alter the primary key , but i am unable to do that. Can you please check my query and confirm , whether the syntax is correct or not as per snaplogic.
Alter table snaplogic.tbl_audit_log drop primary key
Alter table snaplogic.tbl_audit_log DROP CONSTRAINT (etl_last_updated,application,projectName)
Alter table snaplogic.tbl_audit_log ADD CONSTRAINT id PRIMARY KEY(etl_last_updated,application,projectName, id)
