Database Tables List

[Ivan Howard]

Hi All,

Would anyone be able to help me with the following?

For a report, I need to be able to get a list of actual tables within a database... is this possible?

Thanks for reading!
Ivan

 

[raskew]

Hi -

Copy/paste this to a new query:

SELECT msysObjects.Name
FROM msysObjects
WHERE (((msysObjects.Type)=1) AND ((Left([Name],4))<>"Msys"));

HTH - Bob

 

[Ivan Howard]

Thanks very much Bob - this is exactly what I need!

Much appreciated!