IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    Changing non-nullable column to nullable in SQL Server is quick and painless

    Haidong Ji发表于 2016-09-18 18:35:06
    love 0

    In T-SQL, you can only ALTER COLUMN one at a time. Initially I was worried about operational cost of this change, but it turned out this change is instantaneous.

    Mind you, I’m not suggesting you should do this without a good reason.



沪ICP备19023445号-2号
友情链接