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 <http://www.mailscanner.info/> MailScanner, and is
believed to be clean.
_____
Descargá GRATIS el poder del nuevo Internet Explorer 7. Internet
<http://optimized.msn.com/Default.aspx?mkt=es-ar> Explorer 7
--
This message has been scanned for viruses and
dangerous content by <http://www.mailscanner.info/> 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.
<<image001.jpg>>
