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 ArrangementLines
--delete from ArrangementLinesIdentity
--delete from ArrangementLinks
delete from ArrangementReservationsXtab
delete from ArrangementRoomXtab
delete from Attachment
delete from PERSONELTURNOVER
--delete from provision
delete from AddressMail
delete from FOLIOS
delete from reservationAddress
--delete from ReservationAddressIdentity
delete from RESERVATIONADDRESSXTAB
--delete from reservationattachment
delete from RestaurantReservations
delete from ReservationFollowUpXTab
--delete from reservationiden
delete from ReservationMeetingXTab
delete from RESERVATIONNOTES
delete from FollowUp
delete from RESERVATIONCONFERENCELINE
delete from RESERVATIONROOMLINEXTAB
delete from RESERVATIONROOMLINE
--delete from ReservationRoomLineIdentity
delete from ReservationRoomLineSubTypeXTab
--delete from RESERVATIONROOMLINEXTAB
delete from reservations
delete from RESERVATIONMAIN
delete from roombookingstatus
delete from Universallog
--delete from YieldIdentity
delete from YieldPointOfSalesXtab
delete from YieldProductTypeXtab
delete from YieldRoomTypeXtab
delete from YieldSegmentXtab
delete from YieldSubTypeInsale
delete from Yield

