16.20 - name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Name of the new database.

For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.

Example: Creating a New Database

To create a new database for the Finance department, use the CREATE DATABASE request as follows.

    CREATE DATABASE finance FROM sysadmin 
    AS PERMANENT = 60000000, 
       SPOOL = 120000000, 
       FALLBACK PROTECTION, 
       AFTER JOURNAL, 
       BEFORE JOURNAL, 
       DEFAULT JOURNAL TABLE = finance.journals, 
       ACCOUNT = 'ACCTG';

The finance database is created from the space available in sysadmin. The 60,000,000 value represents the amount of storage in bytes. To create a database, the initiator must have CREATE DATABASE privileges on the FROM user or database. The new database receives all privileges that have been granted to the initiator.

In the example, the FROM clause allocates space for finance from the sysadmin space rather than from user space; therefore, sysadmin is the immediate owner of finance, and marks is not in the hierarchy of ownership. However, marks is granted automatic creator privileges on finance, which include the privilege to create other objects in the space owned by finance.

The CREATE DATABASE statement does not include the PASSWORD and STARTUP clauses or the DEFAULT DATABASE and COLLATION options. Because these clauses and options affect the session environment, and only a user can establish a session, they do not apply to a database.