BDNA Data Platform 5.4 July 2017 (SQL Server) CAT_WINDESKTOP_COMPATIBILITY - Windows Desktop compatibility data
|
View Definition:
CREATE VIEW CAT_WINDESKTOP_COMPATIBILITY (
CAT_WINDOWS_COMPATIBILITY_ID,CAT_COMPATIBILITY_ID,CAT_COMPATIBILITY_TYPE,CREATE_DATE,LAST_MODIFIED_DATE,WIN_32BIT_COMPAT_STATUS,WIN_32BIT_COMPAT_STATUS_DESC,
WIN_32BIT_COMPAT_UPGRADE_PATH,WIN_32BIT_COMPAT_DATE,WIN_32BIT_READINESS,WIN_64BIT_COMPAT_STATUS,WIN_64BIT_COMPAT_STATUS_DESC,WIN_64BIT_COMPAT_UPGRADE_PATH,
WIN_64BIT_COMPAT_DATE,WIN_64BIT_READINESS,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,
COMMUNITY_COMPATIBLE,COMMUNITY_NOT_COMPATIBLE,PRIVATE_FLAG,IS_PRIVATE,PRIVATE_TYPE,GENERATED_DATE,TO_BE_DELETED,TO_BE_DELETED_ON,DELETE_REASON,REPLACEMENT_ID
) AS
SELECT CAT_WINDOWS7_COMPATIBILITY_ID,CAT_COMPATIBILITY_ID,CAT_COMPATIBILITY_TYPE,CREATE_DATE,LAST_MODIFIED_DATE,WIN7_32BIT_COMPAT_STATUS,WIN7_32BIT_COMPAT_STATUS_DESC,
WIN7_32BIT_COMPAT_UPGRADE_PATH,WIN7_32BIT_COMPAT_DATE,WIN7_32BIT_READINESS,WIN7_64BIT_COMPAT_STATUS,WIN7_64BIT_COMPAT_STATUS_DESC,WIN7_64BIT_COMPAT_UPGRADE_PATH,
WIN7_64BIT_COMPAT_DATE,WIN7_64BIT_READINESS,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,
NULL COMMUNITY_COMPATIBLE,NULL COMMUNITY_NOT_COMPATIBLE,PRIVATE_FLAG,IS_PRIVATE,PRIVATE_TYPE,GENERATED_DATE,TO_BE_DELETED,TO_BE_DELETED_ON,DELETE_REASON,REPLACEMENT_ID
FROM CAT_WINDOWS7_COMPATIBILITY
UNION ALL
SELECT CAT_WINDOWS8_COMPATIBILITY_ID,CAT_COMPATIBILITY_ID,CAT_COMPATIBILITY_TYPE,CREATE_DATE,LAST_MODIFIED_DATE,WIN8_32BIT_COMPAT_STATUS,WIN8_32BIT_COMPAT_STATUS_DESC,
WIN8_32BIT_COMPAT_UPGRADE_PATH,WIN8_32BIT_COMPAT_DATE,WIN8_32BIT_READINESS,WIN8_64BIT_COMPAT_STATUS,WIN8_64BIT_COMPAT_STATUS_DESC,WIN8_64BIT_COMPAT_UPGRADE_PATH,
WIN8_64BIT_COMPAT_DATE,WIN8_64BIT_READINESS,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,
COMMUNITY_COMPATIBLE,COMMUNITY_NOT_COMPATIBLE,PRIVATE_FLAG,IS_PRIVATE,PRIVATE_TYPE,GENERATED_DATE,TO_BE_DELETED,TO_BE_DELETED_ON,DELETE_REASON,REPLACEMENT_ID
FROM CAT_WINDOWS8_COMPATIBILITY
UNION ALL
SELECT CAT_WINDOWS10_COMPATIBILITY_ID,CAT_COMPATIBILITY_ID,CAT_COMPATIBILITY_TYPE,CREATE_DATE,LAST_MODIFIED_DATE,WIN10_32BIT_COMPAT_STATUS,WIN10_32BIT_COMPAT_STATUS_DESC,
WIN10_32BIT_COMPAT_UPG_PATH,WIN10_32BIT_COMPAT_DATE,WIN10_32BIT_READINESS,WIN10_64BIT_COMPAT_STATUS,WIN10_64BIT_COMPAT_STATUS_DESC,WIN10_64BIT_COMPAT_UPG_PATH,
WIN10_64BIT_COMPAT_DATE,WIN10_64BIT_READINESS,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,
COMMUNITY_COMPATIBLE,COMMUNITY_NOT_COMPATIBLE,PRIVATE_FLAG,IS_PRIVATE,PRIVATE_TYPE,GENERATED_DATE,TO_BE_DELETED,TO_BE_DELETED_ON,DELETE_REASON,REPLACEMENT_ID
FROM CAT_WINDOWS10_COMPATIBILITY
Possibly Referenced Tables/Views: