Data Source Explorer DB List

Teradata Studio

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

2 REPLIES
Teradata Employee

Re: Data Source Explorer DB List

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.

Re: Data Source Explorer DB List

Perfect!!! That fixed it.

Thank you very much.

-Todd