Today, I am reading through Pinal Dave's blog about adding column in
SQL SERVER....One thing make me surprised that while adding column from SSMS wizard, it goes from following process:
- Create a New Table with new columns
- Insert Data from previous table to new table
- Redo all the keys and constraints
- Drop old table Rename
- the new table to use the old table’s name
SQL SERVER take such time and resource consuming process? Is there any benefit from such long process....