Create Database in Teradata

A Teradata database is a defined logical repository which contains following sample database objects:-

Tables
Views
Macros
Triggers
Functions
Stored Procedures

Attributes that you can specify for creating database are:-

Perm Space – maximum amount of space available for tables
Spool Space – maximum amount of work space available for requests
Temp Space – maximum amount of temporary table space

When you create a Teradata database, you should initiate the command with CREATE DATABASE.

Please note, to create a database you would required administrator privileges.

Below is the example:

CREATE DATABASE Tera_Test FROM Sysdba
AS PERMANENT =100000000, SPOOL = 100000000;

Here database “Tera_Test” is owned by “Sysdba”.