Labs4IT! - How to Display the Dependencies of a View in Microsoft SQL Server 2000

A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is

Title: How to Display the Dependencies of a View in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of displaying the dependencies of a view in Microsoft SQL Server 2000. Views are queried the same way that ordinary tables are queried. However, any table hints used when querying the view are ignored. If you change the name of an object referenced by a view, you must modify the view so that its text reflects the new name. Therefore, before renaming an object, display the dependencies of the object first to determine if any views are affected by the proposed change.

If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.


This Web site is not sponsored by, endorsed by or affiliated with Cisco Systems Inc, Microsoft Corp, Oracle Corp, The Computing Technology Industry Association (CompTIA), or any other certification or technology vendor. Cisco® and Cisco Systems® are registered trademarks of Cisco Systems, Inc. Microsoft, Windows and Windows NT are either registered trademarks or trademarks of Microsoft Corp. Oracle® is a registered trademark of Oracle Corp. A+®, i-Net+™, Network+™, and Server+™ are trademarks and registered trademarks of The Computing Technology Industry Association. (CompTIA). Linux™ is a registered trademark of Linus Torvalds. All other trademarks belong to their respective owners. Web site engine code is Copyright © 2003 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.