Published on: 30 Jan, 2014

How to add new column to table in SQL Server?

Tumblr Digg Google Plus

In this tutorial, you will learn how to add new columns to table in SQL Server. Let's say we have a table called table_product and we want to add two columns named ProductCode and Description.

What you need to do is simply run the following sql script. The new two columns should be added to table_product Table.
ALTER TABLE table_product
ADD ProductCode nvarchar(100),
Description nvarchar(2000)

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.