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
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21132244