DROP TABLE LD0P0PROCESSMETADATA
;
DROP VIEW LD0V0PROCESSMETADATA
;
EXEC sp_rename 'LD0P0NEWPROCESSMETADATA', 'LD0P0PROCESSMETADATA'
;
EXEC sp_rename 'LD0P0NEWPROCESSMETADATA_PKID', 'LD0P0PROCESSMETADATA_PKID'
;
DROP VIEW LD0V0NEWPROCESSMETADATA
;
CREATE VIEW LD0V0PROCESSMETADATA AS 
	SELECT M.*, P.PROCESSOWNERTYPE FROM LD0P0PROCESSMETADATA M
	LEFT JOIN  LD0P0PROCESS P ON M.PROCESSID = P.ID
;