/****** Object: View [dbo].[All_Nodes] Script Date: 2020-12-29 8:47:08 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[All_Nodes] AS SELECT *, 'Core' AS Area FROM Core_Nodes UNION ALL SELECT *, 'Image' AS Area FROM Image_Nodes UNION ALL SELECT *, 'Import' AS Area FROM Import_Nodes UNION ALL SELECT *, 'Product' AS Area FROM Product_Nodes UNION ALL SELECT *, 'Result' AS Area FROM Result_Nodes UNION ALL SELECT *, 'System' AS Area FROM System_Nodes UNION ALL SELECT *, 'User' AS Area FROM User_Nodes ; GO /****** Object: View [dbo].[All_Nodes_History] Script Date: 2020-12-29 8:47:08 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[All_Nodes_History] AS SELECT *, 'Core' AS Area FROM Core_Nodes_History UNION ALL SELECT *, 'Image' AS Area FROM Image_Nodes_History UNION ALL SELECT *, 'Import' AS Area FROM Import_Nodes_History UNION ALL SELECT *, 'Product' AS Area FROM Product_Nodes_History UNION ALL SELECT *, 'Result' AS Area FROM Result_Nodes_History UNION ALL SELECT *, 'System' AS Area FROM System_Nodes_History UNION ALL SELECT *, 'User' AS Area FROM User_Nodes_History ; GO /****** Object: View [dbo].[All_Props] Script Date: 2020-12-29 8:47:08 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[All_Props] AS SELECT *, 'Core' AS Area FROM Core_Props UNION ALL SELECT *, 'Image' AS Area FROM Image_Props UNION ALL SELECT *, 'Import' AS Area FROM Import_Props UNION ALL SELECT *, 'Product' AS Area FROM Product_Props UNION ALL SELECT *, 'Result' AS Area FROM Result_Props UNION ALL SELECT *, 'System' AS Area FROM System_Props UNION ALL SELECT *, 'User' AS Area FROM User_Props ; GO /****** Object: View [dbo].[All_Props_History] Script Date: 2020-12-29 8:47:08 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[All_Props_History] AS SELECT *, 'Core' AS Area FROM Core_Props_History UNION ALL SELECT *, 'Image' AS Area FROM Image_Props_History UNION ALL SELECT *, 'Import' AS Area FROM Import_Props_History UNION ALL SELECT *, 'Product' AS Area FROM Product_Props_History UNION ALL SELECT *, 'Result' AS Area FROM Result_Props_History UNION ALL SELECT *, 'System' AS Area FROM System_Props_History UNION ALL SELECT *, 'User' AS Area FROM User_Props_History ; GO
Rulesoft SQL: ViewsCreateScript.sql Print
Created by: Emil Balogh
Modified on: Tue, 29 Dec, 2020 at 8:09 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.