All Forums Teradata Studio
moveout 4 posts Joined 10/14
09 Oct 2014
Data Source Explorer DB List

In SQL Assistant, I've set my Data Source Explorer DB Tree option to use "Load the databases and users from a Table or View: DBCDatabasesVX". I don't see this functionality in Teradata Studio. Am I missing something?

 

In Studio, I'm concerned that if I manually manage the list of databases new items won't show up automatically. We're in the middle of building out our system, so new databases will be added fairly regularly for some time.

 

Thanks.

 

-Todd

fgrimmer 553 posts Joined 04/09
09 Oct 2014

Todd, By default, Studio uses the 'V' Views (DBC.DatabasesV) to gather the Data Dictionary information. You can set a preference to use the 'VX' views (thus DBC.DatabasesVX'). Go to Window>Preferences and select Teradata Datatools Preferences page. There is an option for Query Preference.

moveout 4 posts Joined 10/14
09 Oct 2014

Perfect!!! That fixed it.
Thank you very much.
-Todd

You must sign in to leave a comment.