Table of Contents
Create View
Creates a new database view.
Sample
<createView viewName="personView"> select id, firstname from person </createView>
Available Attributes
| viewName | Name of the view to create [required] |
|---|---|
| schemaName | Name of the view schema |
| replaceIfExists | Use “create or replace” syntax, introduced in v1.5 |
| NESTED TEXT | SQL for generating the view [required] |
Database Compatiblity
| MySQL | No Issues |
|---|---|
| PostgreSQL | No Issues |
| Oracle | No Issues |
| MS-SQL | “replaceIfExists” not available |
| Sybase | “replaceIfExists” not available |
| DB2 | No Issues |
| Derby | “replaceIfExists” not available |
| HSQL | “replaceIfExists” not available |
| H2 | “replaceIfExists” not available |
| Caché | “replaceIfExists” not available |
| Firebird | No Issues |
| MaxDB | No Issues |
Automatic Rollback Support: YES
