Create View
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
Query: CREATE VIEW V1 AS SELECT EMPID FROM emp
IP SCHEMA is called once for table, column, and statistics for each table in the view definition. Finally, IP SCHEMA is called with DAMOBJ_TYPE_TABLE for View itself to check for object name conflicts.
Sequence of calls to schema to CREATE VIEW
| Call | Search Object – Damobj_Type | Object Name | Purpose |
| 1 | DAMOBJ_TYPE_TABLE | EMP | To validate view definition |
| 2 | DAMOBJ_TYPE_COLUMN | EMP | To obtain columns information |
| 3 | DAMOBJ_TYPE_STAT | EMP | To obtain index information |
| 4 | DAMOBJ_TYPE_TABLE | V1 | To verify object name conflict |