How to query scale value of decimal data types?

• brian.willis

  Mr or Mrs. 500

  Points: 541

  More actions

  May 9, 2011 at 9:06 am

  #239322

  Hi all,

  I'd like to produce via query the precision and scale values of any decimal data type fields in a table. Using sys.columns I am able to get precision but not scale...any ideas on how/if I can squeeze scale in there? Code is:

  SELECTO.name AS Object_Name

  ,c.name AS column_name

  ,t.name AS type_name

  ,c.max_length

  ,c.precision

  /* I'd like to insert scale here */

  FROMsys.columns AS c

  JOINsys.types AS t ON c.user_type_id=t.user_type_id

  JOINsys.objects AS O ON C.object_id = O.object_id

  WHEREO.name = 'MyTableName'

  Thanks for looking!

  Brian

• kipb7

  SSC Rookie

  Points: 45

  More actions

  May 9, 2011 at 9:13 am

  #1321777

  Um, add ,c.scale right after ,c.position

  (sys.columns has a scale column)

• brian.willis

  Mr or Mrs. 500

  Points: 541

  More actions

  May 9, 2011 at 9:17 am

  #1321779

  ha! that's what i get for not looking at a complete listing of fields available for sys.columns...must have skimmed right over it.

  it is a Monday...:hehe: