All Forums Database
Dileep Banala 22 posts Joined 07/08
22 Aug 2008
can we create a schema under a database in teradata?

Hii 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

Fred 1096 posts Joined 08/04
22 Aug 2008

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.

You must sign in to leave a comment.