Archives of the TeradataForum

Message Posted: Wed, 15 Jul 2009 @ 20:23:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello,

Is there any query that would display all the possible object kinds in Teradata? For e.g, consider this query. This displays only objects present in my database.

     SELECT DISTINCT TableKind FROM DBC.Tables;

     TableKind
     ---------
     H
     F
     M
     V
     T
     U

I am interested in getting to know all other possible object kinds supported in Teradata (other than those present in my database).

Is there any query that would give my answer?

Thanks in advance,

Hemanth.

	<Prev	Next>		<<First	<Prev	Next>	Last>>