update t1 set t1.CreatorUser = t2.CreatorUser, t1.CreateDate = t2.RequestDate
from FIES.T_PLAN t1
join FIES.T_PLAN_REQUEST t2 on t2.PlanID = t1.PlanID

ALTER TABLE [FIES].[T_PLAN_REQUEST] DROP CONSTRAINT [FK_T_USERS_T_PLAN_REQUEST_CreatorUser]
GO

ALTER TABLE FIES.T_PLAN_REQUEST DROP COLUMN CreatorUser

GO

/****** Object:  Index [IX_T_PLAN_CreateDate]    Script Date: 24.10.2018 11:39:36 ******/
CREATE NONCLUSTERED INDEX [IX_T_PLAN_CreateDate] ON [FIES].[T_PLAN]
(
	[CreateDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

