IBM Support

Getting the names of all tables from Microsoft Access 97, 2000 or Microsoft SQl 7x, 2000 databases using SQL command within GUI script.

Troubleshooting


Problem

This technote provides solution on getting the names of all tables from Microsoft(R) Access 97, 2000 or Microsoft SQl 7x, 2000 databases using SQL command within GUI script.

Resolving The Problem

Instead of querying system tables directly, you could query the appropriate information schema view to get information.

To get a list of all tables in the Microsoft Access database, you can run the following query:

SELECT Name FROM MSysObjects WHERE Type = 1;

To get a list of all tables in the Microsoft SQL database, you can run the following query:

SELECT * FROM information_schema.tables



[{"Product":{"code":"SSSHDX","label":"Rational Robot"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Scripting","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.20;2003;2003.06.00;2003.06.12;2003.06.13;2003.06.14;2003.06.10","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

155591782

Document Information

More support for:
Rational Robot

Software version:
2002.05.20, 2003, 2003.06.00, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.10

Operating system(s):
Windows

Document number:
328897

Modified date:
16 June 2018

UID

swg21132244