hccfsa
asked on
skipping sys* tables in a query
Hello,
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,'IsSyst emTable') = 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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER