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
Historical Number
155591782
Was this topic helpful?
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