restrict view of msysobjects?

  • Thread starter Thread starter Shivalee Gupta via AccessMonster.com
  • Start date Start date
S

Shivalee Gupta via AccessMonster.com

i have this query:
SELECT [msysobjects].[Name]
FROM msysobjects
WHERE ((([msysobjects].[Type]) In (1,6)));
it shows me a list of my sys objects. how can i restrict the output to
showing only tablenames and not see the rest of the items?
please help!
 
But the system objects are tables, hence why you see them . . .. .
You can add Flags = 0 to the SQL to show just user tables. . . .
 
the output of my query is :
my names of 20 tables and MSysObjects,MSysACEs, MSysQueries,
MSysRelationships, MSysAccessObjects, these 5 things i dont want to see. i
didnt actually understand where to add the flag line in my query code? i
hope u are understanding my question?
 
SELECT [msysobjects].[Name]
FROM msysobjects
WHERE [msysobjects].[Type] In (1,6)
AND Flags = 0
 
u r the best. thanks a ton for that help.
regards,
shivalee
 
Back
Top