2 Comments on “Which command should you use to add a column to an existing table?”

1. Sven says:

   September 30, 2016 at 9:52 am

   MODIFY and CHANGE don’t exist, so they aren’t right.
   INSERT adds data. But we want to add a column to an existing table, so that is not right.
   ALTER table is correct.

   
   
   
   4

   
   
   
   0
2. avalon333 says:

   November 10, 2018 at 7:06 am

   Alter is correct.
   Example:

   use TEST
   ALTER TABLE dbo.Road
   ADD Roadname varchar(255);

   
   
   
   0

   
   
   
   0