Wednesday, July 03, 2013

sql server alter table add column

you can use simple syntax for adding a column in the table. for this the schema need to be modified i.e. alteration of table is required.

check out the syntax.

ALTER TABLE table_name
ADD column_name datatype

Other way to modify the table is to open it in SSMS in design mode.

1 comment:

  1. Simple yet informative. Looking forward to more of such posts.
    I have a suggestion: Please upload some training videos for T-SQL, SSRS, SSIS