Scripting Tables with ALTER with dependencies

• Arsh

  SSCertifiable

  Points: 6354

  More actions

  December 9, 2017 at 4:25 am

  #334041

  Dear Experts,
  Please advise how I can script all the tables of a database with ALTER option . It should script the drop and create of the dependencies like Indices, Constraints .Thanks in advance.

• Jeff Moden

  SSC Guru

  Points: 1004558

  More actions

  December 10, 2017 at 4:19 pm

  #1971486

  Arsh - Saturday, December 9, 2017 4:25 AM

  Dear Experts,
  Please advise how I can script all the tables of a database with ALTER option . It should script the drop and create of the dependencies like Indices, Constraints .Thanks in advance.

  "It Depends".  What is it that you're trying to ALTER on every table?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Arsh

  SSCertifiable

  Points: 6354

  More actions

  December 13, 2017 at 7:58 am

  #1971957

  Jeff Moden - Sunday, December 10, 2017 4:19 PM

  Arsh - Saturday, December 9, 2017 4:25 AM

  Dear Experts,
  Please advise how I can script all the tables of a database with ALTER option . It should script the drop and create of the dependencies like Indices, Constraints .Thanks in advance.

  "It Depends".  What is it that you're trying to ALTER on every table?

  Hi Jeff. I suppose I would become an automation project actually. Needs kinda data analytics /machine-learning. The script has to read the contents of the column and analyze basing on the Max / Min / Avg values and how the data is distributed and then suggest a length /Type and generate alter command . for each column where applies. On a smaller scale , similar lines ,I'm building something that projects Index Rebuilds/Reorganize for all  objects based on an algorithm (counting number of table cols , Index cols / Row Count etc ) that determines the fill factor .