Estructura de una tabla SQL Server

select * from sysobjects where name Like '%tabla/vista%'

select syscolumns.name, systypes.name, syscolumns.length from syscolumns
inner join systypes
on syscolumns.xtype = systypes.xtype
where id = 94675435
order by syscolumns.colid