SQL SERVER select para ver tablas, etc

Tables

select name from sysobjects where xtype='U'

Views

select name from sysobjects where xtype='V'

Triggers

select name from sysobjects where xtype='TR'

All

select name from sysobjects where type in ('U','V','TR')