How to NOT generate the extended data on Views

Comments

• Options

  jamesklett Posts: 13

  November 13, 2009 1:22PM

  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

  0 · Share on Twitter
• Options

  Linda Hawksworth Posts: 194

  November 16, 2009 4:43AM

  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.

  0 · Share on Twitter
• Options

  jamesklett Posts: 13

  November 16, 2009 9:20AM

  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

  0 · Share on Twitter