>>In general, it is not recommended that you access the system tables directly.
>>
>>But...this query will get what you want:
>>
>>SELECT * FROM sysobjects WHERE type='U'
>>
>>-Mike
>
>Thanks - just what I was looking for! By the way, I can understand why you shouldn't change anything in the system tables - but what harm is there in running a select query?
>
>Al
MS doesn't guarante that structure of the system tables wouldn't change in the future. Here's the query that uses information schema which conforms to the SQL-92 Standard.
SELECT * From INFORMATION_SCHEMA.TABLES
WHERE table_type = 'BASE TABLE'
AND table_name <> 'dtproperties'
--sb--