Not exactly that I'm aware of - but sysobjects.xtype indicates what type of
object any give row references.

It char(2) ; 'S' = System table; 'U' = User Table.

There are sevral further possible values for other object types; see BOL

select name
from sysobjects
where xtype = 'U'

would list the names of all the user tables on the database.

> -----Original Message-----
> From: Chip Smith [SMTP:[Email Address Removed] Sent: Tuesday, September 23, 2003 4:13 PM
> To: LazyDBA.com Discussion
> Subject: RE: All_tables vs DBA_TABLES
>
> Mawnin list!
>
> RE: All_tables vs DBA_TABLES vs user_tables,
> Is there a view or table or an sp_ in sql server that separates these two?
>
> TIA
> -- chip
>
MS Sql Server LazyDBA home page