Archives of the TeradataForum

Message Posted: Fri, 22 Mar 2002 @ 18:26:59 GMT

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

My own experience is that it contains the Creator ID (the DATABASEID for the Creator):

sel d1.databasename (named DBName)
  , t.tvmname       (named TBLName)
  , d2.databasename (named CreatorName)

  from dbc.dbase   d1
     , dbc.dbase   d2
     , dbc.tvm     t

  where t.createuid = d2.databaseid
    and t.databaseid = d1.databaseid

order by 1,2;

From my notes, it looks like the column was added about V2R3, although I'm not sure that it was populated with the earliest releases of V2R3.

If the database, user, table (et al) was created before the column was supported, it contains a NULL.

Since my experience is by experimentation, does it fit your findings?

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