Listing all tables

[Ben "SheepCow" O'Neill]

Hi,
I'm looking for a way to list all tables in a database.
The SQL command "SHOW TABLES" doesn't work, (I'm trying it on an Access
database), and I really need to get this to work. Does anyone have any
ideas?

Can you please email me, since I can't check the news groups as often as my
email.

shee...@planetunreal.com

Thanks!

--
Ben "SheepCow" O'Neill
GameSpy Arcade Admin
shee...@gamespyarcade.com
ICQ #: 37758267

[Carlos Eduardo Rojas]

You can use one of these approaches:
1) EXEC sp_tables
2) select * from information_schema.tables
--
Hope this helps,
--------------------------------------
Carlos Eduardo Rojas
MCSE+I, MCDBA, MCSS
"Ben "SheepCow" O'Neill" <shee...@planetunreal.com> wrote in message
news:##slDBrGAHA.254@cppssbbsa05...

[David Sanderson]

Loop through the MSysObjects table. Type is 1.

"Ben "SheepCow" O'Neill" <shee...@planetunreal.com> wrote in message
news:##slDBrGAHA.254@cppssbbsa05...

[john spencer]

Access 97

The following SQL will probably do what you want.

SELECT MSysObjects.Type, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=6));

[Al Jones]

go to http://www.ssw.com.au/SSW/Download/default.asp and take a look at
their Simple Table Documentor
std_ver9-01.zip (Microsoft Access 2000 Version) 56 KB. Their commercial
product didn't do what I needed, but they have what appear to be some
interesting dbase products.
--
** AlJ...@fbns.net
** Alfred...@Yahoo.com
** ICQ me at 70219228

"David Sanderson" <dave.sa...@usa.net> wrote in message
news:uVKtF4r...@cppssbbsa02.microsoft.com...