How to NOT generate the extended data on Views

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

How to NOT generate the extended data on Views

Postby jamesklett » Fri Nov 13, 2009 7:20 pm

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
 
Posts: 9
Joined: Mon Sep 28, 2009 3:26 pm

Postby jamesklett » Fri Nov 13, 2009 7:22 pm

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
jamesklett
 
Posts: 9
Joined: Mon Sep 28, 2009 3:26 pm

Postby Linda Hawksworth » Mon Nov 16, 2009 10:43 am

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.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby jamesklett » Mon Nov 16, 2009 3:20 pm

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
jamesklett
 
Posts: 9
Joined: Mon Sep 28, 2009 3:26 pm


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron