DATABASES and SCHEMATA views: New columns and rows to include personal databases and replication information¶
Attention
This behavior change is in the 2025_02 bundle.
For the current status of the bundle, refer to Bundle History.
When personal databases are enabled and you query ACCOUNT_USAGE.DATABASES, ACCOUNT_USAGE.SCHEMATA, INFORMATION_SCHEMA.DATABASES, and INFORMATION_SCHEMA.SCHEMATA views, you will see new information in the OWNER and TYPE columns, as well as a new columns OWNER_ROLE_TYPE and REPLICABLE_WITH_FAILOVER_GROUPS.
In addition, REPLICABLE_WITH_FAILOVER_GROUPS will indicate whether a database is replicable as part of a failover group.
| Column name | New or existing | Description |
|---|---|---|
| OWNER | Existing | The owner for personal objects. |
| OWNER_ROLE_TYPE | Existing in ACCOUNT_USAGE and SCHEMATA views, new in INFORMATION_SCHEMA view | The owner role of the personal object. |
| TYPE | Existing | The type of personal object, such as PERSONAL DATABASE. |
| REPLICABLE_WITH_FAILOVER_GROUPS | New | Whether the database is replicable as part of a failover group. Returns one of:
|
For more information on personal databases, see Personal Databases.
Ref: 1869, 1880