Get list of tables but not include system tables (SQL Server 2K)?

Question

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?

Accepted Answer

```
select name from sysobjects where type='U'
```

Get list of tables but not include system tables (SQL Server 2K)?

Solution

Problem