NavNodes Table

The NavNodes table stores the list of navigation nodes that are displayed in the navigation bars in Microsoft Windows SharePoint Services.

Warning Modifying the database schema or database structures is unsupported. Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

Columns

Column name Data type Description
SiteId uniqueidentifier ID of the SharePoint site to which the node belongs, available from the Sites table.
WebId uniqueidentifier ID of the subsite to which the node belongs.
Eid int ID of the node.
EidParent int ID of the parent node.
NumChildren int Number of child nodes.
RankChild int Order in which to display this node among its siblings.
ElementType tinyint 0 = Page, 1 = Link, 2 = Dynamic Page.
Url nvarchar URL to which the node points if the ElementType property is a link or if the NavSequence property is set to true.
DocId uniqueidentifier ID of the document to which the node points, when the ElementType property is not a link and the NavSequence property is not set to true; available from the Documents table.
Name nvarchar Name of the node.
DateLastModified datetime Date and time when the node information was last modified.
NodeMetainfo image Reserved.
NonNavPage bit true if "Display in Link Bars" is not set for this node in a client program such as Microsoft Office FrontPage 2003; otherwise, false.
NavSequence bit true if the child nodes are included in a link bar rather than as part of the hierarchical navigation structure; otherwise, false.
ChildOfSequence bit true if the EidParent property is the EID of a node for which the NavSequence property is set to true; otherwise, false.