IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st
  where LCase(st.table_name)= LCase('Hotels') and LCase(sc.column_name)= LCase('CreateDate') ) = 0 then
alter table Hotels 
  add "CreateDate" timestamp
end if;
  
GO

Update Hotels set CreateDate = (select min(LastChanged) from Hotels);

GO

IF (EXISTS(Select * from sys.systrigger where LCase(trigger_name) = LCase('Trig_Hotels_CreateDate')))
THEN Drop trigger Trig_Hotels_CreateDate
END IF

GO

create trigger Trig_Hotels_CreateDate before insert order 2 on
DBA.Hotels
referencing new as new_
for each row
when(new_.CreateDate is null)
begin
  set new_.CreateDate = current timestamp
end