Wednesday, December 26, 2012

How to Add New Column to a Sql Server table

You can use of the below ways to add a new column to a Sql server table. Easiest way is to use the Management Studio.

Open the Sql Server Management studio -> Expand the database node -> Expand the tables -> Expand the specific table -> Right click on columns -> New Column..

Other way is to use a Sql query. Run the below query to add a new column.

NewColumn VARCHAR(200) NULL

No comments:
Write comments
Recommended Posts × +