Looking to query datatype english name f

• dsteinschneider

  SSC Enthusiast

  Points: 160

  More actions

  October 7, 2002 at 3:32 pm

  #78889

  I need a very simple documentation of tables: column name, length, datatype. The reason for this is so an admin can provide this for a couple hundred tables that user level report writers will use.

  I wrote a small query to return this but the datatype is a number. Has anyone ever put together a table of datatype number - datatype name or can point me to what table the datatype names are stored in where I can pull the datatype name from

  TIA

  Doug Steinschneider

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 7, 2002 at 3:40 pm

  #437990

  sysdatatypes which I believe is located in all dbs and does include any user defined datatypes in it as well.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)