How to add column in Table.

Satya Karki4y ago

Accepted answer

Hi, you can add a new column by using the below query.

ALTER TABLE table_name ADD column_name datatype

e.g.

ALTER TABLE UserClaims ADD SignupTime datetime

+3

lalit agnihotri4y ago

alter table userclaims add signuptime datetime

update userclaims set signuptime ='00:00:00.000' //default datetime for old entries

+1

Yazhini MP4y ago

The syntax of adding one column to an existing table by using ALTER TABLE ADD statement.

ALTER TABLE table_name

ADD column_name data_type column_constraint;

When adding a column to a large table, typically you want to add the column and fill the added column with a default value. For example, if you want to add a status column, next is to fill the column with a default value.

+2

Vipin Tiwari4y ago

Use below query to alter the table and make new column as nullable. ALTER TABLE table_name ADD column_name datatype

+2