---
name: netezza-creating_schemas
title: Schemas
description: ''
last-updated: 2024-10-14
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/netezza?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

{:external: target="_blank" .external}
{:shortdesc: .shortdesc}
{:table: .aria-labeledby="caption"}
{:tip: .tip}
{:important: .important}
{:note: .note}
{:codeblock: .codeblock}
{:screen: .screen}
{:caption: .caption}

# Schemas
{: #create-schemas}

## Creating schemas
{: #creating_sch}

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

## Updating retention time interval (time travel) for schemas
{: #updating_rt_sch}

1. Go to **Databases**.
1. Select the database in which the schema that you want to alter is.
1. From the overflow menu, click **Update interval**.
1. 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](https://cloud.ibm.com/docs/netezza?topic=netezza-enablingdisabling_tt&format=markdown).
1. Click **Save**.


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