Share via


Table-Valued Object Properties

These properties appear in the Properties window when you select a table-valued object in Query and View Designer. The table-valued object could be a view, synonym, derived table, or table-valued function. Unless otherwise noted, these properties are read-only in the Properties window.

Note

The properties in this topic are ordered by category rather than alphabet.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

  • Identity Category
    Expands to show the Name and TVO Type properties.

  • Name
    Shows the name of the selected table-valued object.

  • TVO Type
    Shows which type of table-valued object. It can be either a base table, view, table-valued function, or a derived table.

  • Query Designer Category
    Expands to show properties for Alias, Column List, Full Name, and Parameter List.

  • Alias
    Shows the alias for the selected table-valued object. To add or change an alias, type it into the field.

  • Column List
    Shows the columns included in the selected table-valued object. To see them in a separate window, click Column List and then click the ellipses (…) to the right of the property.

  • Full Name
    Shows the name of the selected table-valued object, including additional information such as the schema or data source of the object.

  • Parameter List
    Shows the parameters defined for selected table-valued function. To define a value for the parameters, click Parameter List and then click the ellipses (…) to the right of the property. In the Function Parameters dialog box, type in values. This property is only available when a table-valued function is selected.

See Also

Reference

Add Table Dialog Box (Query and View Designers)

Other Resources

Properties in Visual Database Tools

Working with Tables in Table Designer