create table nodeineterface271125_backup as (select * from nodeinterface);
create table subinterface271125_backup as (Select * from subinterface);
create table hsrp271125_backup as (select * from hsrp);

update nodeinterface set ipdataid=null where ipdataid not in (select ipdataid from ipdata);
update nodeinterface set ipdatav6id=null where ipdatav6id not in (select ipdataid from ip_data_v6);
update subinterface set ipdataid=null where ipdataid not in (select ipdataid from ipdata );
update subinterface set IPDATAV6ID=null where IPDATAV6ID not in (select ipdataid from ip_data_v6 );
update hsrp set hsrpipid=null where hsrpipid not in (select ipdataid from ipdata) and hsrpipid not in (select ipdataid from ip_data_v6);


commit;