How to create our own database in Teradata

Tools
Enthusiast

How to create our own database in Teradata

Hi

I Have just installed DemoCD of Teradata V2R5.
How to create a sample database for DemoCD.
and how to create tables under it?

which utility should i use?

Thanks
4 REPLIES
Enthusiast

Re: How to create our own database in Teradata

Hi Dilip,

Ya in Teradata we can create our Own data base as much as you can. But there are some restriction ,

Note : Not like other RDBMS , Before creating any DB or tables , we need to make sure that need to include schema & DB prefix to ur table name

-Also check with ur DBA , wehter u have CREATE GRANTS on your schema , user on those DB.
Ex:

CREATE DATABASE

for Table creation CREATE TABLE

1) SET or MULTISET ( by default it will be set )

let me knwo if you need any more clarification.

Enthusiast

Re: How to create our own database in Teradata

One more thing , for creation of tables & dbs , there is no need to use ultility . you can create it alone in SQL Assistant

If you want to do that in a Utility , that also you can do it in the Scripts.

Re: How to create our own database in Teradata

hi

what is the syntax of creating ourown database in teradata express?

Junior Contributor

Re: How to create our own database in Teradata

The same syntax as always:

CREATE DATABASE db [FROM owner] AS PERM = xxx;

Dieter