Teiid is compatible with a subset of the DDL commands for creating or dropping temporary tables and manipulating procedure and view definitions at runtime. It is not currently possible to arbitrarily drop or create non-temporary metadata entries. For information about the DDL statements that you can use to define schemas in a virtual database, see DDL metadata.

To make non-temporary metadata updates persistent, you must configure a MetadataRepository. For more information, see Runtime Metadata Updates in the Developer’s Guide.