Archive Contacts

From TrialWorks Wiki
Jump to: navigation, search
USE [TrialWorksArchive]
GO
 
--ContactType
EXEC sp_rename 'ContactType', 'ContactType_org'
GO
 
CREATE VIEW [dbo].[ContactType]
AS
SELECT * FROM TrialWorks.dbo.[ContactType] 
GO
 
--Contact Types
EXEC sp_rename 'Contact Types', 'Contact Types_org'
GO
 
CREATE VIEW [dbo].[Contact Types]
AS
SELECT * FROM TrialWorks.dbo.[Contact Types] 
GO
 
--Contacts
EXEC sp_rename 'Contacts', 'Contacts_org'
GO
 
CREATE VIEW [dbo].[Contacts]
AS
SELECT * FROM TrialWorks.dbo.Contacts 
GO