How do I view the database Explorer in Teradata SQL Assistant?

How do I view the database Explorer in Teradata SQL Assistant?

Teradata SQL Assistant for Microsoft Windows User Guide Select View > Explorer Tree.

How do I add a database explorer to Teradata SQL Assistant?

Teradata SQL Assistant. Next Connect by clicking the connect Icon in the upper left corner of your window. If the desired database does not show up in the Explorer Tree, it can be added to the list of available databases by right-clicking in the Explorer Tree and selecting “Add Database” as shown below.

How do I view tables in Teradata SQL Assistant?

Teradata SQL Assistant for Microsoft Windows User Guide Select Tools > List Tables.

What is Teradata SQL Assistant?

Teradata SQL Assistant/Web Edition is a Web-based query tool that enables you to compose a query, submit it to the Teradata Database and view the results from a Web browser. Then you can save the data on your PC for analysis.

How do I log into Teradata SQL Assistant?

To connect to an ODBC data source

1. Use the provider drop down menu to select ODBC data source.
2. Do one of the following: Select Tools > Connect. On the toolbar click . The prompt asks for the name of the data source.
3. Select a data source and click OK.
4. In the Teradata Database Connect dialog box:

How can I see all databases in Teradata?

As @dnoeth mentioned, you can get a list of databases by querying the DBC. databasesV table. If you want to also see the hierarchy, you can see the OwnerName in that table and create the hierarchy from that parent/child relationship.

How do I get all items in Teradata?

Syntax: Option 1 : select * from dbc.

How do I list all databases in Teradata?

How do I use SQL Assistant?

15.00 – Connecting to an ODBC Data Source – SQL Assistant

1. Use the provider drop down menu to select ODBC data source.
2. Do one of the following: Select Tools > Connect. On the toolbar click .
3. Select a data source and click OK.
4. In the Teradata Database Connect dialog box:

How do I get multiple answer sets in SQL Assistant?

How to display multiple Answerset windows in SQL Assistant.

1. Click on Tools.
2. Click on Options.
3. Click on the ‘General’ tab.
4. Off the 4 check box options, select the following: a.
5. You would also see a set of radio button choices with the following label: a.
6. Choose “Each Resultset”.
7. Click OK.

How do I download Teradata SQL Assistant?

Alternatively, you can also download Teradata SQL Assistant and Teradata ODBC driver individually from the Teradata official download page. Step 2: Once you downloaded the package, simply extract and install it like any other software in Windows and lunch Teradata SQL Assistant Software.