IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'pal_Doctor')
BEGIN
EXEC sp_rename 'pal_Doctor', 'pal_MedicalDoctor'
END
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'pal_ICD10')
BEGIN
EXEC sp_rename 'pal_ICD10', 'pal_MedicalICD10'
END
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'pal_Practice')
BEGIN
EXEC sp_rename 'pal_Practice', 'pal_MedicalPractice'
END
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'pal_Procedure')
BEGIN
EXEC sp_rename 'pal_Procedure', 'pal_MedicalProcedure'
END


