All Forums Database
ramesh_td 9 posts Joined 01/14
24 Jun 2014
Types of Tablekind

In teradata there are 3 basic types of Database objects. they are 
1. View
2. Table
3. Macro
are there any other different type of Db objects available?

Tags:
ulrich 816 posts Joined 09/09
24 Jun 2014

your can run a
 
select tablekind from dbc.tables group by tablekind order by tablekind;
so see which are currently existing in your system. 
By the way tablekind is very much missleading - as it is much more objectkind.
In addition the data dictionary documentation will give you the explanation what the different tablekinds are:
 
Possible Values for the Original_TableKind Column
T Data Table
V View
M Macro
J Journal Table
I Join Index Table
P Stored Procedure
G Trigger
F Scalar UDF
A Aggregate UDF
N Hash Index Table
U User-defined Data Type
H Instance or Constructor Method
E External Stored Procedure
R Table Function
X Authorization

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Raja_KT 1246 posts Joined 07/09
25 Jun 2014

You can see thus: select distinct tablekind from dbc.tables. Next you see, requesttext for all those tablekind like select * frm dbc.tables maybe.
It can be misleading if you consider it from the standpoint of DB objects( if you come from other DB background).
It also leads me to think of  Objecttype from  DBQLObjTbl  :) 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.