Using extended properties on the DB objects. What is it?  | Member | | Join Date: Aug 2009 Location: Pune, India
Posts: 76
| |
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.
|  | Expert | | Join Date: Jun 2007
Posts: 1,925
| | | re: Using extended properties on the DB objects. What is it?
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
| | Member | | Join Date: Aug 2009 Location: Pune, India
Posts: 76
| | | re: Using extended properties on the DB objects. What is it?
Quote:
Originally Posted by 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 Hi
Thanks for your reply.
|  |
Similar Microsoft SQL Server bytes | | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,471 network members.
|
