Where is the Description property of a table column stored

• Charlottecb

  Hall of Fame

  Points: 3932

  More actions

  February 4, 2005 at 9:45 am

  #74858

  Hi (SQL Server 2000).

  I want to store a user friendly version of each column name in the table in each columns description.

  Where is this information actually stroed in SQL Server 2000. I want to be able to retrieve a list of columns for a passed table ID (from syscolumns table) and also each column description (user friendly version) - so the user sees something like this...

  Column            Friendly

  intAccountNo

• ron k

  SSCertifiable

  Points: 6103

  More actions

  February 4, 2005 at 2:47 pm

  #540779

  This should help.  It's one of the articles posted today.

  http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp