How to alter SQL to exclude System Tables

[missinglinq]

I'm using the statement below to retrieve the names of the tables in a db into a combobox, but need help to figure out how to exclude the system tables such as MSysObjects, MSysACEs, MSysQueries and so forth.

SELECT [MSysObjects].[Name]
FROM MSysObjects
WHERE ((([MSysObjects].[Name]) Not Like "~*") And (([MSysObjects].[Type])=1));

Thanks!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[PHV]

SELECT [Name]
FROM MSysObjects
WHERE [Name] Not Like '~*' AND [Name] Not Like 'MSys*' AND [Type]=1;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

Thanks, PHV!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[JoeAtWork]

~*

I've never seen this before, what does this cause to be excluded?

Is the ~ a wildcard character?

 

[PHV]

The ~ isn't a wildcard character
Temporary tables or embedded queries have name beginning with a tilde.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886