Yes you can use the sysobjects table for this.
To find the tables you need to look for objects with the xtype = ‘U’, views have an xtype = ‘V’ and procedures have an xtype = ‘P’
WHERE name = ‘U’</pre>
If you have SQL Server 2005 and up the sysobjects table has been replaced by various system management views.
You’ll want to look at the INFORMATION_SCHEMA.VIEW_COLUMN_USAGE and INFORMATION_SCHEMA.VIEW_TABLE_USAGE system views. The INFORMATION_SCHEMA.VIEW_TABLE_USAGE view shows which tables make up which views. The INFORMATION_SCHEMA.VIEW_COLUMN_USAGE view shows which columns make up the views (also handy information to have some times).