Column Description

• cafemar1

  SSCrazy

  Points: 2405

  More actions

  June 4, 2002 at 3:40 pm

  #78459

  Is there a way to get the column description from the tables in a db?

  I created a script to get table and column name, but I have not a clue if I can get the field description. Anyone knows where, if possbile, to get those field descriptions?

  What I have is

  Column1 column2

  Table Column Name

  Employee FName

  we need

  Column1 column2 column3

  Table Column Name Column Desc

  Employee FName First Name

  Any suggestions?

  Thank you

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 4, 2002 at 4:34 pm

  #430332

  See if this article helps any:

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

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter