Archives of the TeradataForum
Message Posted: Fri, 22 Mar 2002 @ 18:26:59 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|