Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Extended property Description Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2002 5:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 1, 2003 12:00 AM
Points: 13, Visits: 1
How can I retrieve the values for the Description Property for a tables columns?
I mean with a T-sql statement.

AW



AW
Post #3352
Posted Tuesday, April 2, 2002 5:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 8, 2006 2:26 AM
Points: 170, Visits: 1

SELECT SysProperties.Value
FROM SysProperties
INNER JOIN SysColumns ON SysProperties.id = SysColumns.id AND
SysColumns.colid = SysProperties.smallid
WHERE (SysProperties.name = 'MS_Description') AND
(Object_name(Syscolumns.id) = <TableName>) AND
(SysColumns.Name = <Columnname>)




Post #30918
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse