When developers want to use a column in a query they must add it to the query. They can add a column a column to display it in query output, to use it for sorting, to search the contents of the column, or to summarize its contents. Developers can decide which of the columns they use in the query are included in the results pane when the query is run. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to add all columns for all tables and table-structured objects, they should follow the next steps:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

1. Make sure no join lines in the Table Operations Pane are selected.

2. Right-click in the empty space of the Design window and choose Properties from the shortcut menu.

3. In the Properties window click Output all columns and choose Yes or No from the dropdown list.