title: Why do I get a different scale for a column when I look in table design and script table vs information_schema and sys.columns?
body: <p>I need to be able to identify (in code) the scale of a sql server column.
  For all of the numeric columns, I get a different answer for scale, depending on where I look for it.</p>
  
  <p>For example if I go the the table designer I will see that a particular column is numeric(17,2). If I go to "Script table as" -> "Create to" -> "New Query window", then I also see that it is numeric (17,2).</p>
  
  <p>However, if I go to information_schema, or sys.columns, I see a precision value of 17 (which is fine) but a scale value of 10 (sys.columns.scale or information_schema.columns.numeric_scale) (which is wrong).</p>
  
  <p>The correct answer is definitely (17,2), but I don't seem to have a way of determining this in my code. Is there some other place I should be looking?</p>