Knowing to use
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
to query for a list of tables, I'm currently finding no way to retrieve a list of non-system tables only.
I.e. the above query also lists me system tables like "sysdiagrams" or "dtproperties".
So my question is:
How to query a database for existance of any user tables?