I know I can get a list of tables from a given database with the following query:
select * from information_schema.tables
How do I go about excluding system tables though?
select name from sysobjects where type='U'