dim @tabla as varchar(20) select @tabla='tablaabuscar' select o.name , c.name from syscolumns c, sysobjects o where c.status & 128 = 128 and o.id = c.id and o.name=@tabla order by o.name