can we create a schema under a database in teradata?

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

can we create a schema under a database in...

Rate Topic

Display Mode

Topic Options

Author

Message

Dileep Banala

Posted 8/22/2008 9:24:13 AM

Junior Member

Group: Forum Members
Last Login: 8/22/2008 11:30:56 AM
Posts: 22, Visits: 41

Hi

i want to know whether we can create a schema in teradata under a database.
similar to how we create a schema in sql or oracle.

does that schema concept is there in teradata or not?

if it is there, please let me know how can we create a schema?

Thanks

Dileep

Post #12697

Fred Pluebell

Posted 8/22/2008 10:31:58 AM

Supreme Being

Group: PAC and SFT Members
Last Login: Today @ 5:24:31 PM
Posts: 328, Visits: 509

Teradata's DATABASE/USER concept can be considered similar to Oracle's SCHEMA.

Any Teradata USER is also a DATABASE, but not all DATABASEs are USERs.

An entire Teradata "system" (sometimes referred to as a "Teradata database", just to confuse things) is sort of like Oracle database+instance.

Post #12700

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 2 ( 2 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 6:10pm