O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Altering a table

SQL Server 2012 allows existing tables to be modified in several ways. By using the ALTER TABLE command, you can make the following types of changes to an existing table.

  • Change the data type or the NULL property of a single column.

  • Add one or more new columns, with or without defining constraints for those columns.

  • Add one or more constraints.

  • Drop one or more constraints.

  • Drop one or more columns.

  • Enable or disable one or more constraints (applies only to CHECK and FOREIGN KEY constraints).

  • Enable or disable one or more triggers.

  • Rebuild a table or a partition to change the compression settings or remove fragmentation. (Fragmentation is discussed in Chapter 7; Chapter 8 discusses compression.)

  • Change the lock escalation behavior of a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required