How to create a database in Teradata

Database
Enthusiast

How to create a 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
2 REPLIES
Enthusiast

Re: How to create a database in Teradata

CREATE DATABASE datbasename
FROM parent
AS
PERM = 100K
SPOOL = 500K
FALLBACK
ACCOUNT= 'ACCTG'
NO AFTER JOURNAL
DUAL BEFORE JOURNAL
DEFAULT JOURNAL TABLE = databasename.journals;
Enthusiast

Re: How to create a database in Teradata

sorry you can use sql assistant to do the same.

-Harsha