Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MODIFY VIEW Command

Visual Studio .NET 2003

Displays the View Designer, making it possible for you to modify an existing SQL view.

MODIFY VIEW ViewName [REMOTE][NOWAIT]

Parameters

ViewName
Specifies the name of the view to modify.
REMOTE
Specifies that the view is a remote view that uses remote tables. If you omit REMOTE, you can modify a view using local tables.
NOWAIT
Continues program execution after the VIEW Designer opens. The program doesn't wait for the VIEW Designer to close, but continues execution on the program line immediately following the line that contains MODIFY VIEW NOWAIT. Without the NOWAIT clause, MODIFY VIEW opens the VIEW Designer and program execution pauses until you close the Designer.

Remarks

SQL views are created with CREATE SQL VIEW.

See Also

CREATE SQL VIEW | OPEN DATABASE

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.