Query for reading tablenames from database

#1

Does anyone now or it's possible to read tablesnames from a database using
sql?

#2

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=4));

Activate the view of the hidden system-tables via the options-menu.

Greetz,

Jeroen

On Mon, 12 Sep 2005 00:47:16 +0200, <automailer (AT) it-products (DOT) nl> wrote:

Quote:

Does anyone now or it's possible to read tablesnames from a database using
sql?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query for reading tablenames from database

comp.database.ms-access comp.database.ms-access

Query for reading tablenames from database - 09-11-2005 , 05:47 PM

Re: Query for reading tablenames from database - 09-12-2005 , 03:41 AM