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:

ss1
I write the following alter table command like this:

Alter Table RaceResults
Add LapsCompleted int

Which returns the following:

ss2

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