SQL Views

A SQL view is a virtual table; it represents a table in a relational database or the results of a database operation or a data service.

A SQL view that points to a database table can be provisioned directly through the database connector for that database. A SQL view that represents the output of a database operation or data service is generated from the database operation or data service in question.

Every SQL view in a Sybase Data Federation domain is part of the domain’s virtual database. SQL views are treated like relational tables by the Data Federation query engine, and you can execute SQL queries against them. SQL view data can be accessed using standard SQL statements in a virtual database operation or by connecting to Data Federation with ODBC or JDBC.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.