DELIMITER $$

ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_contact` AS (
SELECT
  `profile_management`.`m_contact`.`ContactID`              AS `ContactID`,
  `profile_management`.`m_contact`.`EntityID`               AS `EntityID`,
  `profile_management`.`m_contact`.`AddressContactID`       AS `AddressContactID`,
  `profile_management`.`m_contact`.`ContactValue`           AS `ContactValue`,
  `profile_management`.`m_contact`.`IsPrimary`              AS `IsPrimary`,
  `profile_management`.`m_contact`.`ContactTypeID`          AS `ContactTypeID`,
  `profile_management`.`m_contact`.`ReferenceTableStatusID` AS `ReferenceTableStatusID`,
  `profile_management`.`m_contact`.`DateAdded`              AS `DateAdded`,
  `profile_management`.`m_contact`.`AddedbyUserID`          AS `AddedbyUserID`,
  `profile_management`.`m_contact`.`DateUpdated`            AS `DateUpdated`,
  `profile_management`.`m_contact`.`UpdatedbyUserID`        AS `UpdatedbyUserID`
FROM `profile_management`.`m_contact`)$$

DELIMITER ;