Red Gate forums :: View topic - How to NOT generate the extended data on Views
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 2
SQL Doc 2 forum

How to NOT generate the extended data on Views

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
jamesklett



Joined: 28 Sep 2009
Posts: 9

PostPosted: Fri Nov 13, 2009 7:20 pm    Post subject: How to NOT generate the extended data on Views Reply with quote

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
Back to top
View user's profile Send private message
jamesklett



Joined: 28 Sep 2009
Posts: 9

PostPosted: Fri Nov 13, 2009 7:22 pm    Post subject: Reply with quote

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星roperties =
Begin Pane拴onfigurations =
Begin Pane拴onfiguration = 0
Num星anes = 4
Configuration = "(H (1[22] 4[23] 2[20] 3) )"
End
Begin Pane拴onfiguration = 1
Num星anes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin Pane拴onfiguration = 2
Num星anes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin Pane拴onfiguration = 3
Num星anes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin Pane拴onfiguration = 4
Num星anes = 2
Configuration = "(H (1 [56] 3))"
End
Begin Pane拴onfiguration = 5
Num星anes = 2
Configuration = "(H (2 [66] 3))"
End
Begin Pane拴onfiguration = 6
Num星anes = 2
Configuration = "(H (4 [50] 3))"
End
Begin Pane拴onfiguration = 7
Num星anes = 1
Configuration = "(V (3))"
End
Begin Pane拴onfiguration = 8
Num星anes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin Pane拴onfiguration = 9
Num星anes = 2
Configuration = "(H (1 [75] 4))"
End
Begin Pane拴onfiguration = 10
Num星anes = 2
Configuration = "(H (1[66] 2) )"
End
Begin Pane拴onfiguration = 11
Num星anes = 2
Configuration = "(H (4 [60] 2))"
End
Begin Pane拴onfiguration = 12
Num星anes = 1
Configuration = "(H (1) )"
End
Begin Pane拴onfiguration = 13
Num星anes = 1
Configuration = "(V (4))"
End
Begin Pane拴onfiguration = 14
Num星anes = 1
Configuration = "(V (2))"
End
Active星ane拴onfig = 0
End
Begin Diagram星ane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "Time拴ard"
Begin Extent =
Top = 6
Left = 38
Bottom = 301
Right = 203
End
Display政lags = 280
Top拴olumn = 0
End
Begin Table = "Work昱ecord"
Begin Extent =
Top = 26
Left = 410
Bottom = 141
Right = 618
End
Display政lags = 280
Top拴olumn = 0
End
Begin Table = "Labor拴enter"
Begin Extent =
Top = 30
Left = 699
Bottom = 145
Right = 915
End
Display政lags = 280
Top拴olumn = 0
End
Begin Table = "Employee柱ork拴enter"
Begin Extent =
Top = 183
Left = 693
Bottom = 293
Right = 918
End
Display政lags = 280
Top拴olumn = 0
End
Begin Table = "Employee"
Begin Extent =
Top = 188
Left = 414
Bottom = 303
Right = 618
End
Display政lags = 280
Top拴olumn = 0
End
End
End
Begin SQLPane =
End
Begin Data星ane =
Begin Parameter挑efaults = ""
End
Begin Column柱idths = 9
Width = 284
Width = 1500
Width = 2175
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin Criteria星ane =
Begin Column柱idths = 11
Column = 7005
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Nov 16, 2009 10:43 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jamesklett



Joined: 28 Sep 2009
Posts: 9

PostPosted: Mon Nov 16, 2009 3:20 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group