use [LennonHeather]
GO
delete from dbo.matters
delete from dbo.contacts
delete from dbo.Accruals
delete from dbo.ActionWorkTypes
delete from dbo.Allocations
delete from dbo.AssociateTypes
delete from dbo.BankRecClearDown
delete from dbo.BankRecCompleteTrans
delete from dbo.BankRecHistory
delete from dbo.BankRecOutstandingTrans
delete from dbo.BankRecTransactions
delete from dbo.BankTally
delete from dbo.BatchDetails
delete from dbo.BatchH
delete from dbo.BillDescriptions
delete from dbo.BillDetails
delete from dbo.BillFeeBreakDown
delete from dbo.BillHeader
delete from dbo.Branch
delete from dbo.BranchLocation
delete from dbo.BranchNominals
delete from dbo.Calendar
delete from dbo.CaseAssociatesContacts
delete from dbo.CaseAssociatesNames
delete from dbo.CaseAssoicatesTypes
delete from dbo.CaseContacts
delete from dbo.CaseMaster
delete from dbo.CaseMasterClosed
delete from dbo.CasePlanCodes
delete from dbo.CaseTeams
delete from dbo.CaseUDFAnswers
delete from dbo.Category
delete from dbo.CategoryType
delete from dbo.ChargeArrangements
delete from dbo.ChargingMatrix
delete from dbo.ChequeNumbers
delete from dbo.ChequeRequisitionDetail
delete from dbo.ChequeRequisitionHeader
delete from dbo.ChequesForPrinting
delete from dbo.children
delete from dbo.client
delete from dbo.ClientContacts
delete from dbo.CloseCaseContacts
delete from dbo.Closed
delete from dbo.ClosedCaseUDFAnswers
delete from dbo.CloseDiary
delete from dbo.CloseDiaryAttachments
delete from dbo.ClosedMatterLedger
delete from dbo.ContactCategories
delete from dbo.ContactLinks
delete from dbo.ContactPhoneNos
delete from dbo.ContactRequisition
delete from dbo.Contacts
delete from dbo.control
delete from dbo.CostFees
delete from dbo.CostTransGathering
delete from dbo.CourtFees
delete from dbo.csaccounts
delete from dbo.DataFiles
delete from dbo.DebtAccounts
delete from dbo.DebtCostingLedger
delete from dbo.DebtorsLedger
delete from dbo.deeds
delete from dbo.Departments
delete from dbo.DepositType
delete from dbo.DesktopControl
delete from dbo.DesktopNarr
delete from dbo.diary
delete from dbo.DiaryAttachments
delete from dbo.DiaryDelegations
delete from dbo.DocumentClasses
delete from dbo.DocumentPopCat
delete from dbo.DocumentPopups
delete from dbo.EMailAttachments
delete from dbo.FeeEarnerCodes
delete from dbo.FieldTransfer
delete from dbo.FileColours
delete from dbo.FileManagerItems
delete from dbo.Forms
delete from dbo.Handlers
delete from dbo.InterestCalcHistory
delete from dbo.InterestRates
delete from dbo.ItemDiary
delete from dbo.ItemHistory
delete from dbo.ItemLocations
delete from dbo.ItemTypes
delete from dbo.MatterLedger
delete from dbo.MatterLedgerClearDown 
delete from dbo.matters
delete from dbo.MatterTally
delete from dbo.MemorisedBatchD
delete from dbo.MemorsiedBatchH
delete from dbo.MilestoneTypes
delete from dbo.MiscCodes
delete from dbo.MultiBatchD
delete from dbo.MultiField
delete from dbo.NationCodes
delete from dbo.Narratives
delete from dbo.NewNominal
delete from dbo.Nominal 
delete from dbo.NominalLedger
delete from dbo.NominalReportSeq
delete from dbo.NominalTypes
delete from dbo.Officers
delete from dbo.OutlayCode
delete from dbo.OutlayTransfer
delete from dbo.OutlookIds
delete from dbo.PendingOutlay
delete from dbo.RBatchD
delete from dbo.RBatchH
delete from dbo.RecentMatterList
delete from dbo.SAM3Fields
delete from dbo.StatusCodes
delete from dbo.ServiceCodes
delete from dbo.StatusCodes
delete from dbo.StatusId
delete from dbo.Suppliers
delete from dbo.SupplierLedger
delete from dbo.SystemConfig
delete from dbo.SystemFiles
delete from dbo.SystemUserDefinedFields
delete from dbo.TasksCodes
delete from dbo.Team
delete from dbo.TeamMembers
delete from dbo.TemplateActionCommands
delete from dbo.TemplateActionDcouments
delete from dbo.TemplateActions
delete from dbo.TemplateActionTypes
delete from dbo.TemplateActionUDF
delete from dbo.TemplateCopyAssociates
delete from dbo.TemplateDocuments
delete from dbo.TemplateDocumentUDF
delete from dbo.TemplateDocumentUDFs
delete from dbo.TemplateNextActions
delete from dbo.Templates
delete from dbo.TimeAdminCodes
delete from dbo.TimeDayBook
delete from dbo.TimeEntry
delete from dbo.TransferList
delete from dbo.UDFDefinition
delete from dbo.UDFLookups
delete from dbo.UDFTemplatesWorkTypes
delete from dbo.Undertakings
delete from dbo.VATCodes
delete from dbo.Wills
delete from dbo.WorkTypes