DROP.sql

USE DRIVER_SERVICE;

DROP TABLE IF EXISTS ALTERNATIVE_RECEIVER
DROP TABLE IF EXISTS ALTERNATIVE_RECEIVE_PHONE
DROP TABLE IF EXISTS PACKAGE
DROP TABLE IF EXISTS CORDER
DROP TABLE IF EXISTS CUSTOMER_RECEIVE
DROP TABLE IF EXISTS CUSTOMER_SEND
DROP TABLE IF EXISTS DRIVES
DROP TABLE IF EXISTS DRIVER
DROP TABLE IF EXISTS EMPLOYEE
DROP TABLE IF EXISTS PERSON_MAIL
DROP TABLE IF EXISTS PERSON_PHONE
DROP TABLE IF EXISTS VEHICLE
DROP TABLE IF EXISTS ACCOUNT
DROP TABLE IF EXISTS PERSON
DROP TABLE IF EXISTS KILOMETER_DISTANCE
DROP TABLE IF EXISTS PRICE_RATIO
DROP TABLE IF EXISTS SALARY_BILL
<<<<<<< HEAD
DROP TABLE IF EXISTS SERVICE_TYPE
DROP TABLE IF EXISTS ACC_PHONE
DROP TABLE IF EXISTS LINKAGE
DROP FUNCTION IF EXISTS GET_RATIO_FROM_SSN
DROP FUNCTION IF EXISTS COST_FOR_CUSTOMER_SEND
DROP FUNCTION IF EXISTS COST_ORDER
DROP FUNCTION IF EXISTS GET_SALARY_EMPLOYEE
DROP FUNCTION IF EXISTS AVE_RP
drop procedure if exists InsertAccount
=======
--DROP FUNCTION IF EXISTS GET_RATIO_FROM_SSN
--DROP FUNCTION IF EXISTS COST_FOR_CUSTOMER_SEND
--DROP FUNCTION IF EXISTS COST_ORDER
--DROP FUNCTION IF EXISTS GET_SALARY_EMPLOYEE
DROP FUNCTION IF EXISTS AVE_RP
>>>>>>> 86f2a3d8bffcf111b0bfccc2f6be5714c336188c