Bárbaro, Hernan. Gracias.
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [dbadmin] {Spam?} Descripcion de una columna...
Date: Wed, 26 Mar 2008 15:45:32 -0300
Gracias mariano:
Me sirvió para SQL 2000 te comento que en 2005 no funciona
porque hay q hacerlo de esta manera
SELECT
[Table Name] = OBJECT_NAME(c.object_id),
[Column Name] =
c.name,
[Description] =
ex.value
FROM
sys.columns c
LEFT OUTER JOIN
sys.extended_properties
ex
ON
ex.major_id = c.object_id
AND ex.minor_id = c.column_id
AND ex.name = 'MS_Description'
WHERE
OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0
AND OBJECT_NAME(c.object_id) = 'TABLENAME'
ORDER
BY OBJECT_NAME(c.object_id), c.column_id
De: [email protected]
[mailto:[EMAIL PROTECTED] En nombre de Mariano Dios
Enviado el: Miércoles, 26 de Marzo de 2008 11:44 a.m.
Para: Ricci Mauro
Asunto: {Spam?} [dbadmin] Descripcion de una columna...
Hola
Hernan,
La descripcion de una columna sale de la tabla SysProperties, dentro de tu db.
SELECT Value
FROM SysProperties
WHERE Id = 1685581043
Y el Id del objeto lo sacas de la tabla SysObjects, tambien dentro de tu db,
para la tabla que contiene a la columna en cuestión.
Mariano
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [dbadmin] Descripcion de una columna...
Date: Wed, 26 Mar 2008 11:29:49 -0300
Hola
gente de la lista.. alguien sabe como obtener a través de una consulta la
descripción de una columna de una tabla..??
--
This message has been scanned for viruses and
dangerous content by MailScanner,
and is
believed to be clean.
Descargá
GRATIS el poder del nuevo Internet Explorer 7. Internet
Explorer 7
--
This message has been scanned for viruses and
dangerous content by MailScanner,
and is
believed to be clean.
--
This message has been scanned for viruses and
dangerous content by
MailScanner, and is
believed to be clean.
_________________________________________________________________
¿Aburrido? Ingresá ya y divertite como nunca en MSN Juegos.
http://juegos.ar.msn.com/<<attachment: image001.jpg>>
