How to change column padding for existing table?

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  May 17, 2017 at 9:29 am

  #336881

  We need to change padding (it is reflected in is_ansi_padding from sys.columns) for a column in existing table. We don't want to drop/create table.

  Thanks

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  May 17, 2017 at 9:35 am

  #1942955

  SQL Guy 1 - Wednesday, May 17, 2017 9:29 AM

  We need to change padding (it is reflected in is_ansi_padding from sys.columns) for a column in existing table. We don't want to drop/create table.

  Thanks

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/937c502f-48e5-4aac-aa8c-ef29c286689d/changing-ansipadding-on-a-table?forum=sqldatabaseengine

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden