Monday, October 18, 2010

Adding new column to SQL SERVER DB table

Here is the process to add new column to existing db table  in SQL SERVER.

Create sampleStudTable(Id int,Name Varchar(100))
GO

To add additional column to this db table;
ALTER TABLE sampleStudTable
ADD Discipline Varchar(100) NULL

Reference: http://blogwithdp.blogspot.com/

No comments:

Post a Comment