



ALTER PROCEDURE DBO.DeleteAllReservations AS
SET NOCOUNT ON

-- KJ20050808: Removed some tables

delete from ReservationAttachmentXTab
delete CustomerAttachmentXTab
delete personalFollowUpXTab
--delete from reservationlog
delete from AccountDaily
delete from ArrangementReservationsXtab
delete from ArrangementRoomXtab
delete from ArrangementLines
--delete from ArrangementLinesIdentity
--delete from ArrangementLinks
delete from Attachment
--delete from PERSONELTURNOVER
--delete from provision
delete from RESERVATIONADDRESSXTAB
delete from reservationAddress
--delete from ReservationAddressIdentity

--delete from reservationattachment
delete from RestaurantReservations
delete from ReservationFollowUpXTab
--delete from reservationIdentity
delete from ReservationMeetingXTab
delete from ReservationReservationXtab
delete from ResvConfLineConfRmStatusXtab
delete from RESERVATIONNOTES
delete from FollowUp
delete from RESERVATIONCONFERENCELINE
delete from RESERVATIONROOMLINEXTAB
delete from RESERVATIONROOMLINE
--delete from ReservationRoomLineIdentity
delete from ReservationRoomLineSubTypeXTab

delete from ReservationExternalRefXtab
Delete from ReservationsExt
delete from RESERVATIONMAIN
delete from reservations
delete from roombookingstatus
delete from RoomBookingStatusInsale
delete from RoomBookingStatusYield
delete from Universallog
--delete from YieldIdentity
delete from YieldPointOfSalesXtab
delete from YieldProductTypeXtab
delete from YieldRoomTypeXtab
delete from YieldSegmentXtab
delete from YieldSubTypeInsale
delete from YieldOnlineRoomTypesXTab
delete from YieldColorXTAB
delete from Yield
Delete from IdentityReservationAddressNumber
delete from IdentityReservationRoomLineNumber
delete from IdentityFields Where DBTableName = 'RESERVATIONIDENTITY'