Archives of the TeradataForum
Message Posted: Thu, 20 Feb 2003 @ 03:49:24 GMT
You could try something like this:
sel createtext from dbc.tvm where databaseid = (sel databaseid from dbc.dbase where databasename='dbc');
Above I have used 'dbc' as the databasename, you could specify your own databasename. You could also restrict the kind of object definition that you are trying to retrieve, based on the field dbc.tablekind.
Hope this helps.
Narayan Murthy K S
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|