Archives of the TeradataForum

Message Posted: Thu, 25 Oct 2012 @ 22:25:07 GMT

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

I'm not the developer so I can't be sure but based on what I use in SQL Assistant my guess would be:

     DatabasesVX
     TablesVX
     ColumnsVX
     FunctionsVX
     IndicesVX
     TriggersVX
     UDTInfoV      (<== not sure if you need this but I don't think there is an X view)

You may however need additional views for functionality other than simply retrieving the names for the Tree. (Teradata Studio displays more than just the names in their Teradata View and I don't know when they load that info.)

Mike Dempsey

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