Sybase Views

Sybase Views is used to get the data from one or more tables. A view is simply named select statement that is stored in a database as an object. It allows you to view a subset of rows or columns in one or more tables.

Why Views:

Security: Using a view, we can query and modify only the data we can see. The rest of the database is neither visible nor accessible.

Views can shield users from changes in the structure of the real tables if such changes become necessary.

Define frequently used joins, projections, and selections as views so that users do not have to specify all the conditions and qualifications each time an operation is performed on that data.

Display different data for different users, even when they are using the same data at the same time. This advantage is particularly important when
users of many different interests and skill levels share the same database.