Using extended properties on the DB objects. What is it?

[OraMaster]

Hi All,

Below is the SQL of one view in my DB.

SELECT     cxc.cst_key AS q37_individual_key, dbo.co_individual.ind_cst_key AS q37_related_ind_key, dbo.co_individual.ind_prf_code AS q37_prf_code, 
                      dbo.co_individual.ind_first_name AS q37_first_name, dbo.co_individual.ind_last_name AS q37_last_name, 
                      dbo.co_individual.ind_mid_name AS q37_ind_mid_name, dbo.co_individual.ind_sfx_code AS q37_sfx_code, 
                      dbo.co_individual.ind_gender AS q37_gender, dbo.co_individual.ind_deceased_flag AS q37_deceased_flag, 
                      dbo.co_individual_ext.ind_death_date_ext AS q37_death_date_ext, dbo.co_individual_ext.ind_membership_id_ext AS q37_membership_id_ext, 
                      cxc.cxc_rlt_code AS q37_rlt_code, cxc.cxc_start_date AS q37_start_date, cxc.cxc_end_date AS q37_end_date
FROM         (SELECT     cxc_cst_key_1 AS cst_key, cxc_cst_key_2 AS cst_key_2, cxc_rlt_code, cxc_start_date, cxc_end_date
                       FROM          dbo.co_customer_x_customer
                       WHERE      (cxc_rlt_code =
                                                  (SELECT     TOP (1) fws_option_values
                                                    FROM          dbo.fw_system_option
                                                    WHERE      (fws_key = '3ab8d879-5c2d-480e-8bd0-360aaabb9cae'))) AND (cxc_end_date IS NULL OR
                                              cxc_end_date <= GETDATE())
                       UNION ALL
                       SELECT     cxc_cst_key_2 AS cst_key, cxc_cst_key_1 AS cst_key_2, cxc_rlt_code2 AS cxc_rlt_code, cxc_start_date, cxc_end_date
                       FROM         dbo.co_customer_x_customer AS co_customer_x_customer_1
                       WHERE     (cxc_rlt_code =
                                                 (SELECT     TOP (1) fws_option_values
                                                   FROM          dbo.fw_system_option AS fw_system_option_1
                                                   WHERE      (fws_key = '3ab8d879-5c2d-480e-8bd0-360aaabb9cae'))) AND (cxc_end_date IS NULL OR
                                             cxc_end_date <= GETDATE())) AS cxc INNER JOIN
                      dbo.co_individual ON cxc.cst_key_2 = dbo.co_individual.ind_cst_key INNER JOIN
                      dbo.co_individual_ext ON dbo.co_individual.ind_cst_key = dbo.co_individual_ext.ind_cst_key_ext
 
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[25] 4[3] 2[56] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "co_individual"
            Begin Extent = 
               Top = 6
               Left = 230
               Bottom = 121
               Right = 441
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "co_individual_ext"
            Begin Extent = 
               Top = 6
               Left = 479
               Bottom = 121
               Right = 758
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "cxc"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 192
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'vw_client_ri_individual_spouses'
 
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'vw_client_ri_individual_spouse'

Can anyone pls explain me the code below of create view SQL. I am not getting why and how these extended properties are neing used in this code.

[ck9663]

It's very hard to answer your question without knowing what this query is for, what kind of application it is designed for, why is it needed to be created, etc...

But you may start from learning what is extended property here.

Good luck!!!

--- CK

[OraMaster]

@ck9663
Hi

Thanks for your reply.