Navigation Overview
The information in a Microsoft® SQL Server™ 2000 Meta Data Services repository is a network of objects and relationships. You navigate through this network using collections. Depending on your objective, you can retrieve an object collection, a relationship collection, or some other special-purpose collection.
Typically, you navigate to an object because you want to manipulate it. Manipulations include retrieving or setting a property, deleting an object, deleting a relationship between two objects, or adding a relationship between two objects.
The following figure represents a relationship between a Table origin object and a Column destination object. The relationship type is table has columns. In this relationship, one table can have many columns.
Subsequent topics explore the navigable relationships and strategies that you can implement based on this single origin-destination pairing of Table to Column.
The following topics provide this information.
| Topic | Description |
|---|---|
| Navigating a Relationship from Two Directions | Describes how you can navigate a relationship from either object in the relationship |
| Navigating a Relationship Using Two Approaches | Describes alternate approaches for navigating |