How to Rename a View in Microsoft SQL Server 2000
Date: Tuesday, March 21 @ 00:21:39 EST
Topic: Microsoft SQL Server Online Training Demos, Tutorials


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

Title: How to Rename a View in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of renaming a view in Microsoft SQL Server 2000. After a view is defined, you can change its name or modify its definition without dropping and re-creating the view, thereby losing the permissions associated with the view. Altering a view does not affect any dependent objects, such as stored procedures or triggers, unless the definition of the view changes in such a way that the dependent object is no longer valid.

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









This article comes from Labs4IT!
http://www.labs4it.com

The URL for this story is:
http://www.labs4it.com/article857.html