Displaying View Data

Remember that the information in a view is not stored separately in the database. Each time you refer to the view, SQL executes the associated SELECT statement to find the appropriate data. This means that if the sales data changes, information in the view will be automatically up to date.

You can query a view just like a table:

SELECT *
FROM emp_dept

To see the results in Sybase Central, right-click the View, choose View Data in Interactive SQL.