Archives of the TeradataForum

Message Posted: Thu, 20 Feb 2003 @ 03:49:24 GMT

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

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
Wipro Technologies

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