in
Innovasys Logo

Exclude Indexes, Relationships, SQL from SQL Server Database output file

Last post 06-16-2008 2:07 PM by Scott. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-13-2008 7:41 AM

    • Scott
    • Top 100 Contributor
    • Joined on 07-19-2007
    • Posts 2

    Exclude Indexes, Relationships, SQL from SQL Server Database output file

    I am in the process of creating functional database documentation intended to describe the usage of tables and columns. The audience does not need to see Indexes, Relationships, Objects that <table> Depends On, SQL, or See also sections for each of the tables. Is there any way to exclude these from being included in the output file? My preference is to keep them in the Content File, but just exclude them from the generated .chm file. Any suggestions for manipulating the output once generated would also be welcome.

    Filed under:
  • 06-13-2008 8:24 AM In reply to

    Re: Exclude Indexes, Relationships, SQL from SQL Server Database output file

    Hello,

    With the dxc open for edit you can select an item in the Tree View and then use the "Is Excluded" flag remeber to check the "Is Excluded from Table of Contents" flag also. Once an item is marked with the "Is Excluded" flag you should see that it is now marked with a red cross in the Tree View. This will allow you to see the items in the Content File but exclude them from the output at build time.

    Mike Shaw
    Innovasys
    http://www.innovasys.com
  • 06-16-2008 9:38 AM In reply to

    Re: Exclude Indexes, Relationships, SQL from SQL Server Database output file

    I think that you were actually asking how to exclude particular sections from the table page. The way to do this would be to create a custom Template and edit the table page layout to remove the sections that you don't want to see. You could then set your project to use the custom template. You could still use the original template whilst working in the Content File editor by choosing the Edit Template in the Content File properties dialog.

    Richard Sloggett
    Innovasys
    http://www.innovasys.com
  • 06-16-2008 2:07 PM In reply to

    • Scott
    • Top 100 Contributor
    • Joined on 07-19-2007
    • Posts 2

    Re: Exclude Indexes, Relationships, SQL from SQL Server Database output file

    Thank you. I was able to accomplish what I was trying to do. For any other new users trying to accomplish a similar task, here is how it was done.

    • Go to Tools > Configuration and then select Templates
    • Click Add New and create a new Template by copying one of the existing Database templates
    • Select Page Layouts under content
    • For those entire sections that you definitely want to exclude (for me, that included Indexes, views, and a couple others), highlight and press Delete. There are some others that seem to be related to navigation that I retained.
    • The part I was missing though, was to highlight the one called table.html and press Edit. From there you simply select the sections you don't want to be included in the output file and delete them.
    • On the main tab for the Project, select Template and Locale under Style on the left and choose the newly created template.

    Also, you can actually associate a different Template in the Content File Properties. This way, you can see all of the relationships, etc, but the output will reflect the custom template.

Page 1 of 1 (4 items)