[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Pivot Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Gauges
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Collapse]Query Builder
   [Expand]Getting Started
    Binding to Data
    Selecting Tables
    Joining Tables
   [Expand]Shaping Data
    Previewing Results
    Obtaining the Resulting Query
    Localizing the Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Selecting Tables

You can add a specific table or view to a query by dropping the corresponding item from the Available Tales and Views list onto the design surface.

Enable the checkboxes for the table columns you want to include in the query result set.

You can search for a specific table or view by typing in the dedicated search box above the tables list.

The Table Properties panel allows you to specify a custom table name.

In the same way, you can select a specific column and define its Alias in the Column Properties panel.

Click an empty space on the design surface to display the Query Properties panel where you can type the query name.

Use the Delete button in the Query Builder Toolbar to remove the selected table from the query.

The Undo button enables you to cancel the last change made to the query. Click the Redo button to reverse the last undo action's result.

Is this topic helpful?​​​​​​​