USE MEDSMS
go

truncate table AutoSMS
truncate table Company
truncate table Inquiry
truncate table MessageNumber
truncate table MobileProvider
truncate table MsgTemplate
truncate table ReadMessages
truncate table SMSLog
truncate table Subscriber
truncate table SubscriberGroup




USE MSYS
go

truncate table Contact
truncate table Logbook
truncate table Staff
truncate table Person