Thread: Table in sql server

How to add new column in table in sql server

I am learning SQL language. I have created one table. This table has four columns. I would like to insery new column to this table but I don’t know how to do this. Can anybody tell me how to add new column in table in SQL server. Any help.

It is very easy procedure. In this condition you have to use Alter table command. Try to understand following example. In following program I have create one column with size 15.

ALTER TABLE USermaster ADD UserType VARCHAR(15) NULL;