Schemas

Creating schemas

1. Go to Databases.
2. Select the database in which you want to create a schema.
3. Click Create schema.
4. Type a name for the schema. If the name contains special characters, enclose it in double quotation marks. The dot character (".") is not supported.
5. Specify the retention time interval (in days) for the schema.
6. Click Create.

Updating retention time interval (time travel) for schemas

1. Go to Databases.
2. Select the database in which the schema that you want to alter is.
3. From the overflow menu, click Update interval.
4. Type a retention time interval. You can select between 1 day and up to 99 days, or zero to alter a temporal schema to nontemporal. For more information on retention time interval and time travel, see NPSaaS time travel.
5. Click Save.

You can select Set as default schema, Assign owner, Rename, Update interval, Drop restrict and Drop cascade options from the overflow menu.