SELECT DISTINCT MSysObjects.Name FROM MSysObjects; how if i want to get only tables? any help
M mhmaid Jan 16, 2006 #1 SELECT DISTINCT MSysObjects.Name FROM MSysObjects; how if i want to get only tables? any help
J Jeff Conrad Jan 16, 2006 #2 SELECT MsysObjects.Name FROM MsysObjects WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1)) ORDER BY MsysObjects.Name; -- Jeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conradsystems/accessjunkie.html http://www.access.qbuilt.com/html/articles.html in message:
SELECT MsysObjects.Name FROM MsysObjects WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1)) ORDER BY MsysObjects.Name; -- Jeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conradsystems/accessjunkie.html http://www.access.qbuilt.com/html/articles.html in message:
R Rob Parker Jan 16, 2006 #3 Add "WHERE Type = 1" to your SQL. To exclude the system tables, use: SELECT DISTINCT MSysObjects.Name FROM MSysObjects WHERE Name Not Like "msys*" AND Type=1; HTH, Rob
Add "WHERE Type = 1" to your SQL. To exclude the system tables, use: SELECT DISTINCT MSysObjects.Name FROM MSysObjects WHERE Name Not Like "msys*" AND Type=1; HTH, Rob
M mhmaid Jan 16, 2006 #4 thanks to both of you for respose and help . tested both and it is working perfect. thanks again.
