Add Column To Existing Table


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.

Leave a Reply

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close