Why does column default look like this - ((0))

  • I want a default of 0 for a column. When I create this default in Management Studio, the formatting of the default looks like this:
     
    ((0))
     
    instead of just 0
    Does anyone know why the two sets of parenthesis are added by Management Studio?
     
    Just curious,
    Mike Chabot
  • Yeah, that's weird.  It only happens after you save the table.  And when you script the table the double parens are listed there too.

    37SOLUTIONS
    Guidance and Oversight for Critical Technology Decisions
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | IT Consulting

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply