|   | ![]() |
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Just as with all of the others, selecting the Views item will display all views in a database.
Double clicking a view will open the view editor. The first tab is one of the most useful things that could have been provided. How many people have been working with a view and had a datatype mismatch. In order to resolve it you had to dig around in the view definition and the base tables. The first tab already resolves that for you and gives you the datatypes of each column in the view. The Definition tab allows you to modify the view definition. The Privileges and Dependencies tabs function the same as the other editors.
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.