can we create a schema under a database in teradata?

Database
Enthusiast

can we create a schema under a database in teradata?

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
1 REPLY
Teradata Employee

Re: can we create a schema under a database in teradata?

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.