Previous Topic: Include DROP Statements in DDL (Gen All)Next Topic: Downstream Effects


Qualify Tables and Indexes with Owner ID

An owner ID is a string used as an implicit qualifier for table names and index names. The ID applies to the execution of every SQL statement. In the DDL, owner IDs appear as a prefix to table and index names in CREATE and DROP statements.

This feature is useful for allowing multiple individuals to have their own test databases on the same workstation.