What are the challenges you face when working across database platforms? Take the survey
Options

How to NOT generate the extended data on Views

jamesklettjamesklett Posts: 13
edited November 16, 2009 9:20AM in SQL Doc Previous Versions
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

Comments

  • Options
    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
  • Options
    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.
  • Options
    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
Sign In or Register to comment.