Alter Table (Table Name)
Add (Column Name) data type varchart(255)
I have a table named RaceResults, and I want to add a LapsCompleted column. Here is how the table currently looks:
I write the following alter table command like this:
Alter Table RaceResults
Add LapsCompleted int
Which returns the following:
The NULL values are expected, but now that you have the column added, you can update these values. That will be covered in a separate article.