Repeat for each column you want to add to the view.Ĭlick the name of the column whose properties you want to define, and then click Edit. To change the name of the column, click the default column name and type a new name. The default name for the new column follows the naming conventions you specified in the Modeling Preferences dialog box. Repeat for each column you want to add to the view.Ĭlick Add.
Open the database model diagram that contains the view you want to add columns to.ĭouble-click the view, and then in the Database Properties window, in the Categories list, click Columns.Ĭlick the Physical Name field of a blank line and type the name of the column. Add a view to a database model diagramįrom the Entity Relationship or Object Relational stencil, drag a View shape onto the drawing page.
See Can't find the database modeling features? for more information. Note: The Database Model diagram is only available in certain versions of Visio.
