Creating, Editing, and Deleting Queries Associated with Views

You can edit queries associated with a view from the SQL Query tab of the view property sheet.

Any number of queries may be associated with a view, and the totality of their SQL statements is shown in this tab, linked by any of the standard SQL constructs, such as Union, etc.

• Editing Query Code in the SQL Query Tab
  You can edit the code shown in the SQL Query tab in any of the following ways:
• Opening the Property Sheet of a Query
  Each query associated with a view has its own property sheet, which contains the following tabs:
• Query Property Sheet SQL Tab
  This tab displays the SQL code for the query.
• Query Property Sheet Tables Tab
  This tab lists the tables in the FROM clause, which specify where the query data will be drawn from.
• Query Property Sheet Columns Tab
  This tab lists the columns in the SELECT clause, which specify what data will be displayed in the query.
• Query Property Sheet Where Tab
  This tab lists the expressions in the WHERE clause, which restrict the data retrieved by the query.
• Query Property Sheet Group By Tab
  This tab lists the columns in the GROUP BY clause, which control how the data retrieved by the query will be grouped.
• Query Property Sheet Having Tab
  This tab lists the expressions in the HAVING clause, which restrict the data returned by a query with a GROUP BY clause.
• Query Property Sheet Order By Tab
  This tab lists the columns in the ORDER BY clause, which control the way in which the data retrieved by the query will be sorted.

---

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com