How to NOT generate the extended data on Views

jamesklett

When I generate my documentation the file contains pages and pages of code for all my views describing the layout of the view. I do not want nor do I need that. How do I turn this feature off ?

JIM

jamesklett

I guess it is DIAGRAM data, looks like this (I cant figure who would want this in the documentation anyway)

[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin Design¬Properties =
Begin Pane¬Configurations =
Begin Pane¬Configuration = 0
Num¬Panes = 4
Configuration = "(H (1[22] 4[23] 2[20] 3) )"
End
Begin Pane¬Configuration = 1
Num¬Panes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin Pane¬Configuration = 2
Num¬Panes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin Pane¬Configuration = 3
Num¬Panes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin Pane¬Configuration = 4
Num¬Panes = 2
Configuration = "(H (1 [56] 3))"
End
Begin Pane¬Configuration = 5
Num¬Panes = 2
Configuration = "(H (2 [66] 3))"
End
Begin Pane¬Configuration = 6
Num¬Panes = 2
Configuration = "(H (4 [50] 3))"
End
Begin Pane¬Configuration = 7
Num¬Panes = 1
Configuration = "(V (3))"
End
Begin Pane¬Configuration = 8
Num¬Panes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin Pane¬Configuration = 9
Num¬Panes = 2
Configuration = "(H (1 [75] 4))"
End
Begin Pane¬Configuration = 10
Num¬Panes = 2
Configuration = "(H (1[66] 2) )"
End
Begin Pane¬Configuration = 11
Num¬Panes = 2
Configuration = "(H (4 [60] 2))"
End
Begin Pane¬Configuration = 12
Num¬Panes = 1
Configuration = "(H (1) )"
End
Begin Pane¬Configuration = 13
Num¬Panes = 1
Configuration = "(V (4))"
End
Begin Pane¬Configuration = 14
Num¬Panes = 1
Configuration = "(V (2))"
End
Active¬Pane¬Config = 0
End
Begin Diagram¬Pane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "Time¬Card"
Begin Extent =
Top = 6
Left = 38
Bottom = 301
Right = 203
End
Display¬Flags = 280
Top¬Column = 0
End
Begin Table = "Work¬Record"
Begin Extent =
Top = 26
Left = 410
Bottom = 141
Right = 618
End
Display¬Flags = 280
Top¬Column = 0
End
Begin Table = "Labor¬Center"
Begin Extent =
Top = 30
Left = 699
Bottom = 145
Right = 915
End
Display¬Flags = 280
Top¬Column = 0
End
Begin Table = "Employee¬Work¬Center"
Begin Extent =
Top = 183
Left = 693
Bottom = 293
Right = 918
End
Display¬Flags = 280
Top¬Column = 0
End
Begin Table = "Employee"
Begin Extent =
Top = 188
Left = 414
Bottom = 303
Right = 618
End
Display¬Flags = 280
Top¬Column = 0
End
End
End
Begin SQLPane =
End
Begin Data¬Pane =
Begin Parameter¬Defaults = ""
End
Begin Column¬Widths = 9
Width = 284
Width = 1500
Width = 2175
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin Criteria¬Pane =
Begin Column¬Widths = 11
Column = 7005

Linda Hawksworth

Which version of SQL Doc are you running? Version 2.x has the option to uncheck the "Include SQL creation script in generated documentation" which won't document any of the object creation scripts.

jamesklett

I have the latest version, and YES I have selected that option, however, the stuff I am referring to in this thread is NOT SQL creation script. Take a close look at it again. WHat it is, is size and position data for designing views that trells SQL server where to draw the boxes representing the tables in the view.

When you design a View you add tables and you connect them and you drag the around and size them so that it is easy to read. When you close the View and re-open it, SQL server nicely re-draws everything just like you left it.

JIM