Udostępnij za pośrednictwem


Table-Valued Objects

You can use table-valued objects in queries or views. These objects can hold information from many different tables and can therefore reduce the number of tables you must use in a query. A table-valued object can be a table, a view, a function, a synonym, or a local table. You can see table-valued objects in the Query Designer's Diagram pane when you open a view or create a query.

You can use a view, synonym, or local table just as you would a table. When you use a table-valued function you'll need to assign a value to its parameters before you can run the query. To do this, select the table-valued function in the Diagram pane, and then in the Properties window click the ellipses (…) beside Parameter List.

See Also

Other Resources

Working with Tables in Table Designer

Working with Stored Procedures and User-Defined Functions

Designing Queries and Views