CREATE TABLE unit
(
  unit_Id int NOT NULL,
  name nvarchar(255)
);


ALTER TABLE drug ADD quantity_composition float;
ALTER TABLE drug ADD quantity_dose float;
ALTER TABLE drug ADD unit_composition int;
ALTER TABLE drug ADD unit_dose int;
ALTER TABLE drug DROP COLUMN strength;
ALTER TABLE drug DROP COLUMN strength_uom;

