what happens when you change a table?

• ksexton

  SSCrazy

  Points: 2790

  More actions

  August 2, 2002 at 9:10 am

  #58518

  I know if you change a datatype in a table that has values sql server creates a whole new table and then drops the old one.

  When does it do that and when does it not do that?

  If I change a column that is an int to be a seed column does it create a whole new table?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  August 2, 2002 at 9:19 am

  #433909

  Most changes require a rebiuld of the table because the physical structure changes. If you change the table in EM, the third button from the left is a script button. Click that to see what is changing.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones