skipping sys* tables in a query
Posted on 2008-02-04
I'm trying to do a query to select all user tables and apparently SQL server marks system tables like sysarticles and sysdiagrams as user tables. "WHERE ObjectProperty(sysobjects.id,'IsSystemTable') = 0" or "WHERE sysobjects.xtype = 'U'" just don't do. I can't filter by the table names also, because we have many tables that start with "sys". So any suggestions? Thank you very much.