How to Alter Table in SQL Server 2008
In this article I am going to explain how to alter a table in SQL .
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
Statement that add new column in table
ALTER TABLE dbo.emp_info
ADD Company VARCHAR(50)
|
Output
Now we see that there are seven column