How to Alter Table in SQL Server 2008

In this article I am going to explain how to alter a table in SQL .
  • 2196

Introduction

In this article I am going to explain how to alter a table in SQL . Alter TABLE statement is used to Alter table in SQL server.

Statement that add new column in table

ALTER TABLE dbo.emp_info
ADD ADDRESS VARCHAR(50)

Output

Clipboard02.jpg

Statement that add new column in table

ALTER TABLE dbo.emp_info
ADD Company VARCHAR(50)

Output

Clipboard04.jpg

Now we see that there are seven column

Clipboard06.jpg


© 2019 DotNetHeaven. All rights reserved.