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.
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
- Supported Query Types (Visual Database Tools)
Describes the query types you can use with the Query and View Designer.
- How to: Create Full-Text Search Queries (Visual Database Tools)
Describes how to create a query that searches a full-text indexed column.
- How to: Create Insert Results Queries (Visual Database Tools)
Describes how to create a query that inserts the results of a SELECT statement into a table.
- How to: Create Insert Values Queries (Visual Database Tools)
Describes how to create a query that inserts values into a table.
- How to: Create Make Table Queries (Visual Database Tools)
Describes how to create a query that creates a new table.
- How to: Create Delete Queries (Visual Database Tools)
Describes how to create a query that deletes data.
- How to: Create UNION Queries (Visual Database Tools)
Describes how to create a query that merges the results of two or more SELECT statements into one result set.
- How to: Create Update Queries (Visual Database Tools)
Describes how to create a query that updates a table.
Reference
- Query Properties (Visual Database Tools)
Describes the properties available to you when designing queries.
Related Sections
- Designing Queries and Views (Visual Database Tools)
Describes how to design and manipulate queries and views.