Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
The Query and View Designer provides built-in features for some query types (Select, Insert Results, Insert Values, Update, Delete, and Make Table) and also supports UNION, Full-text search, and CASE expression queries.
In this section
| Article | Description |
|---|---|
| Supported Query Types | Describes the query types you can use with the Query and View Designer. |
| Create Full-Text Search queries | Describes how to create a query that searches a full-text indexed column. |
| Create Insert Results queries | Describes how to create a query that inserts the results of a SELECT statement into a table. |
| Create Insert Values queries | Describes how to create a query that inserts values into a table. |
| Create Make Table queries | Describes how to create a query that creates a new table. |
| Create Delete queries | Describes how to create a query that deletes data. |
| Create UNION queries | Describes how to create a query that merges the results of two or more SELECT statements into one result set. |
| Create Update queries | Describes how to create a query that updates a table. |