Para los que les fastidia el exceso de informacion de sp_help en sql server:
create proc vertabla
@tabla varchar(30)
as
select
'Clave' = case when syscolumns.colstat=1
then '---->' else ' ' end,
convert(varchar(30), syscolumns.name) as Nombre,
convert(varchar(30), systypes.name) as Tipo,
syscolumns.length as Largo,
'Nulo'= case when syscolumns.isnullable=1
then 'Si' else 'No' end
from
syscolumns
inner join systypes on
syscolumns.xtype=systypes.xtype
where id in(select id from sysobjects where name=@tabla)
go
cualquier duda, me avisan...
Luis