Getting a list of tables thru SQL

  • Thread starter Thread starter jdebeer
  • Start date Start date
J

jdebeer

On Dev Ashish's site there is a code snippet to get a list of tables
but this ode only shows the actual tables in the mdb. What is the
code to also show the linked tables.

Thanks

jdb



SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND
((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;
 
jdebeer said:
On Dev Ashish's site there is a code snippet to get a list of tables
but this ode only shows the actual tables in the mdb. What is the
code to also show the linked tables.

SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND
((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;
Click to expand...


SELECT MsysObjects.Name
FROM MsysObjects
WHEREMsysObjects.Type=6
ORDER BY MsysObjects.Name;
 
Thanks very much

jdebeer said:
On Dev Ashish's site there is a code snippet to get a list of tables
but this ode only shows the actual tables in the mdb. What is the
code to also show the linked tables.

SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND
((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;
Click to expand...


SELECT MsysObjects.Name
FROM MsysObjects
WHEREMsysObjects.Type=6
ORDER BY MsysObjects.Name;
Click to expand...
 
Back
Top