Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Table-Valued Object Properties (Visual Database Tools)

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.

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

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu.

Identity Category

Expands to show the Name and TVO Type properties.


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.


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.

Community Additions

© 2015 Microsoft