The following sql will create the cdw view from CDA table cda.ExternalCredentialPathway.
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Cdw].[ExternalCredentialPathway_v]')) EXEC dbo.sp_executesql @statement = N'CREATE VIEW [Cdw].[ExternalCredentialPathway_v] AS SELECT x.ExternalCredentialPathwayID, x.ExternalCredentialID, x.PathwayID, x.LastModifiedDateTime, x.IsDeleted, CdwRowVersion = x.LastUpdateRowVersion FROM cda.ExternalCredentialPathway x '