SQLQuery2.sql

delete from user_health where login like '%salvador%'

select * from user_health;

delete from patient;

select * from patient where id_user = '55c94d36-9dcf-4a3f-8f55-48b2f759dd2c';



select * from PATIENT_HAS_TAG;

delete from patient_has_tag where mac_code = '0x4B-0x42-0x91-0xAB';

select * from user_health where login like '%salvador%'

delete from patient where id_patient = 'F8313B58-F807-4098-A74B-64BF456FA838';

select * from user_health;

drop table deficiency;

drop table PATIENT_HAS_DEFICIENCY;

drop table PATIENT_DID_SURGERY;

drop table FAMILY_MEMBER;

select * from PHYSICIAN_SPECIALIZATION where name_en like '%health%';


INSERT INTO PHYSICIAN_SPECIALIZATION VALUES(NEWID(), 'Assistencia clínica', 'Clinicial assistants', 'FS');

delete from PHYSICIAN_SPECIALIZATION WHERE id_specialization = 'CD1CC773-E6F6-4587-986A-BEF075E8C967';