there were few entries which are not table or atleast not created by me
like

MSpub_identity_range


there was other command that I used previously

select name from sysobjects where xtype = 'U' and status > 0 order by name

was there any error in this

Rajesh

>>how to get list of user defined table from the database
>
>You can uses information schema which conforms to SQL-92 Standard.
>

>SELECT * From INFORMATION_SCHEMA.TABLES
>	WHERE table_type = 'BASE TABLE'
>		AND table_name <> 'dtproperties'
>