Visual Database Tools
Creating Queries
The Query Designer features an easy-to-use interface for working with your queries. The topics in this section describe the fundamentals of working with any query, including how to choose a table or table-structured object to work with, how to add or remove data columns from the query, and how to execute the query.
To | See |
---|---|
Add or remove tables or table-structured objects from a query | Adding Tables Removing Tables |
Add or remove columns from a query or from the query output | Adding Columns Removing Columns from Query Output Removing Columns from the Query |
Change how query results are displayed | Reordering Output Columns Ordering Query Results |
Clear or print the query results | Clearing Query Results Printing Query Results |
Create aliases for tables or columns | Creating Table Aliases Creating Column Aliases |
Check the syntax of a query | Verifying a Query |
To run or stop a query | Executing a Query Stopping a Query |